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:
tblQueries
and create the following new query:TicketAccountable (name is arbitrary)
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
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.