Fig.: Result of the configuration is another module tab in the main dialog.
In this example, the dialog shown is a tab of the main dialog. An organized tree structure is shown, whose nodes are loaded at the first access. The records shown in the list are reloaded directly from the database when the nodes are selected. Date and number values are formatted according to the DB column definition.
You set up the connection to the data source in Web Configuration > General > Connections > Other Databases
. In this case, a second i-net HelpDesk test database has been used. If the add-on should display internal HelpDesk data, e.g. statistical or other data from views or self-created tables, "HDS" i.e. the HelpDesk database could also be used as the name.
Fig. 2: Configure database connection
DatasourceName=DB1 SelectionGrouping=Abteilung SelectionColumn=tblUser.UsrID;Nachname SelectionFilter=geloescht=0 TableLinkedColumn= tblGeraeteBestand.UserID ShowColumn1=tblGeraeteBestand.GerBezeichnung;Geraet ShowColumn2=tblGeraeteTypen.Bezeichnung;Typ ShowColumn3=tblGeraeteBestand.Kostenstelle;Kostenstelle ShowColumn4=tblGeraeteBestand.KaufDatum;Erwerb ShowColumn5=tblGeraeteBestand.Preis;Preis ShowColumn6=tblVerkaeufer.Name;Verkaeufer TableReferenz1=tblGeraeteBestand.GTyID;tblGeraeteTypen.GtyID TableReferenz2=tblGeraeteBestand.VerkID;tblVerkaeufer.VerkID
Line | Explanation |
---|---|
DatasourceName=DB1 | Name of the datasource connection defined in Web Configuration > General > Connections |
SelectionGrouping=Department | "TableName" "." "ColumnName" according to which data nodes are assigned to grouping nodes. I.e. all users are grouped to the departments. |
SelectionColumn=tblUser.UsrID;LastName | Describes the assignment of the nodes in the second level to the data records loaded in the list. This entry is composed as follows "Table name" "." (dot as separator) "Column name Key value" ";"(semicolon as separator) "Column name for node text". |
SelectionFilter=deleted=0 | Optional SQL expression that restricts the amount of data in the tree. Since deleted and department are columns of the same table as the user nodes (tblUser), specifying the table is not mandatory. |
TableLinkedColumn= tblGeraeteBestand.UserID | Identifies referenced table and column in the foreign data source: i.e. the comparison value record key value, which must match the node key value. |
ShowColumn1=tblGeraeteBestand.GerBezeichnung;Geraet | ShowColumnX must be numbered continuously starting at 1. This is followed by "table name" "." "column name" (database field from which the display value is to be taken) ";" and the "text of the label displayed for the field". |
TableReference1=tblGeraeteBestand.GTyID;tblGeraeteTypen.GtyID | Since in this example the list is filled with data from three tables, two relations are required for the definition. |
TableReference2=tblGeraeteBestand.VerkID;tblVerkaeufer.VerkID |
TableReference X must be numbered consecutively starting at 1. In general, if n tables are displayed, there must be n-1 relations between them. So one table 0 relations....
The file must be located in the path of the variable HelpDesk program data.
C:\ProgramData\i-net software\helpdesk_System_i-net HelpDesk
/root/.i-net software/helpdesk_System_i-net HelpDesk
/var/root/.i-net software/helpdesk_System_i-net HelpDesk
helpdesk_System_i-net HelpDesk
will be created below it.
Add-ons are configured in the Web Configuration > Components > Add-Ons
. In the example, the specific definition of the add-on is located in the text file Definition.txt
created in point 2.
Fig. 4: Create add-on