Chapter 6: User Interface

Using Queries

The query editor will now allow the worker to build an expression based upon the Last query. The option “--[last query]--” is one of the options in the Based on drop-down list, which allows the worker to “get” the query expression from the last query performed. If a last query has not been established for the current session, then an appropriate message will be displayed.

To Create a New Query

1Click Work items > Queries > New query.

2Select a query option from the Based on drop-down list, then click Get Expression. The Name field will populate the associated name of the query.

3Click Run. The results will display in the Items list at the bottom of the page.

4If you would like to save this query, you must give the query a name in the Name box.

5Click Save.

6Workers may view the Last query results run by selecting the option Work items>Last query results

listed below Commands or Last query results listed below Common tasks.

If the worker saved the query to a new name, the query will appear in the Based on: drop-down list as well as in the List query page once the browser is refreshed.

Modify New Query Search

Helpdesk Solution has a parameter replacement system so that input can be solicited whenever the query is run.

Note that the query system only works against the most recent version of all work items - workers cannot query against work item history directly unless they type in valid Transact-SQL sub-select statements that query against the workitem_detail_view view.

To Modify a Query Search

1Click Work items > Queries > New query.

2Usually, it is easiest to modify the codes of an existing query. Select an existing query from the Based on drop-down list.

3Click Get Expression.

Altiris Helpdesk Solution User Guide

72