TabList

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

Fig. 1: Result of the configuration is another tab with data in a list

In the example described below, user data referenced by the order's identifier field is displayed (the identifier value "Engineering" is used to display the employees of the "responsible" department). This example was chosen because only one HelpDesk database (or its copy) is required for its implementation.

Note: For understanding, a look at the description of the i-net HelpDesk database design is helpful. We are happy to send the document to our customers upon request.

1. Set up connection to the 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

Fig. 3: Create configuration file

Line Explanation
DatasourceName=DB1 Name of the database connection defined in Web Configuration > General > Connections
HelpDeskReferenzField=tblAuftraege.spezFeld Specification of the text field from which the comparison value for the query comes. In the described case it is identifier "Technique". If it were the field "tblUser.department", all users from the ticket owner's department would be displayed in the above example.
ForeignReferenceField=tblUser.Department Identifies referenced table and column in the foreign data source: i.e. the comparison value of the records that should have the same value as the "HelpDeskReferenceField".
ShowColumn1=tblUser.Username;Username ShowColumnX must be numbered consecutively starting at 1. After that follows "TableName" "."(dot as separator) "ColumnName" (database field from which the display value should be taken) ";"(semicolon as separator) and the "ColumnHeader in Client" (here identical to the column name in the database).

If data from multiple tables/views is to be displayed, the relations between the tables must also be specified.

  • ShowColumn4=tblGebaeude.GebBezeichnung;Client
  • TableReference1=tblUser.GebID;tblGebaeude.GebID

TableReference X must be numbered consecutively starting at 1. In general, if n tables are displayed, there must be n-1 relations between them. Thus a 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