Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Query restricted order

Highlighted
Alfio Torrisi
Collector

Query restricted order

Hi,

i would like use query restricted in ServiceCalls views to make more performance my servicedesk 5.1.

I would like it shows last service calls opened: but the system show them without order.... can you help me to restict view in rational mode?

thank you!!!
1 REPLY
Mike Bush
Honored Contributor

Re: Query restricted order

Alfio, I'm afraid you cannot achieve what you want. Query restriction is applied on the unsorted data returned so you are at the mercy of the way the DB returns the data. From empirical data (trial and error) it seems to be the OLDEST data which comes back but some AMENDMENTS cause records to move around the DB and hence not be "so old"

You should view query restriction as a "safety valve" to prevent overload of database and network - users should NOT be hitting it in their regular work - they should have more specific views to let them work without hitting the limit - if they cannot then the limit is too low!
//Add this to "OnDomLoad" event