Query: Selection from a list of terms

The newly created query determines all i-net HelpDesk users who have not been deleted and who are members of a resource. After that, an ascending sorting is performed according to the display name.

How to proceed:

  • Open MS SQL Management Studio, connect to i-net HelpDesk database, table tblQueries and create the following new query:
  • QueryID: TicketAccountable (name is arbitrary)
  • Query: SELECT DISTINCT tblUser.Vorname + ' ' + tblUser.Nachname AS Displayname FROM tblUser INNER JOIN tblRessourcenUser ON tblUser.UsrID = tblRessourcenUser.UsrID WHERE (tblUser.geloescht = 0) ORDER BY Displayname
    • The query may only return values without semicolons.
    • The query must be one-to-one
    • The query should return only one column. In case of multiple columns the value of the first column is taken

Important: All queries should return only one column. For text addition, the query must return ascending sorted values.

Note: Currently, customizing the database is the only way for this desired feature. Since i-net HelpDesk is constantly being adapted and improved, no functional guarantee can be given for user-defined adjustments to the database.