1 of 1 people found this helpful
The whole query is run at once.
I should probably have expanded on my issue a little further.
Within console you click on a query and it pops up a input box to let you insert the values to bind to the query, and then run the query with these.
Within webdesk when you click on a query it gives you a form at the top to insert the values, however it also runs the query without any values to display at the bottom.
I want to be able to either not run the query or run it with some default value bindings initially to reduce the first database hit.
Just to make sure, you posted your question in the Management Suite area. Based on your further explanation and terminology, I have a sneaking suspicion you use Service Desk. If so, you might get much better results posting it in the appropriate area of this community.
Good observation. I did not notice. Thank you.
No problem, glad we noticed in time
Good luck in the other section!