Helpdesk Solution - Sorting Worker Queries List

Why on earth would you want to sort your worker query list? For easy reading of course! The following tip will help you sort your list for easier management and viewing. Ready... set... sort!

List of queries to be updated to have the list sorted on the worker page:

Select * from Query
Where expression like ‘%worker_query%’

Worker Query:

Select * from worker_query 

to be changed to

Select * from worker_query order by name

WorkerQueryViewList:

Select * from worker_query_view

To be change to

Select * from worker_query_view order by worker_query_name

Restart MSSQLServer Service

Restart IIS

Thanks,

Dom