Resource Dynamics, Inc.

Tele-Support HelpDesk Hot Tips

Problem:

The Find Inquiry module does not sort its results by Inquiry Number.

Solution:

Note: This will require a database modification. We strongly recommend having a backup of your HelpDesk database before making the changes referenced below.

To force the Find Inquiry module to sort by Inquiry Number, please do the following:

1) Open the HelpDesk database in either Access or SQL Enterprise Manager, depending on the HelpDesk version appropriate to your circumstance.

2) Open the "Queries" (Access) or "Views" (SQL) list for your HelpDesk database and locate the entry called "VIEWFINDINQUIRY".

3) Append the following SQL statement to the end of the "VIEWFINDINQUIRY" SQL query:

    ORDER BY INQUIRY.INQNO

4) Save these changes and then exit and restart HelpDesk. The Find Inquiry module should now sort by inquiry number.

Applicable Versions:

3.0, 3.1, 3.2. 3.2.1, 4.0.