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.
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
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.
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.
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