TreeList

Example in the "Requests" module (There is NO reference to a ticket field.)

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.

1. Set up connection to data source

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

2. Creating the configuration file

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.

  • Windows: C:\ProgramData\i-net software\helpdesk_System_i-net HelpDesk
  • Linux: /root/.i-net software/helpdesk_System_i-net HelpDesk
  • Mac: /var/root/.i-net software/helpdesk_System_i-net HelpDesk
  • Note: If you had already configured an alternative storage path for attachments for HelpDesk version 7.x, then this path will be used as "root" and the structure helpdesk_System_i-net HelpDesk will be created below it.

3. Defining the "TabList" add-on

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