Chapter 6: User Interface

Using Queries

Query Parameter Replacement

There are a number of special parameters that the query system recognizes. When a query is run the parameters are resolved and the results are returned. With the exception of $current_worker_id$, all queries containing parameters will present an intermediate page where the worker can provide input.

$current_worker_id$

The parameter $current_worker_id$ will automatically be resolved to the ID of the credential worker. The resolved parameter will not be quoted.

Example [My open items]:

workitem_assigned_to_worker_id = $current_worker_id$ and workitem_status_lookup_id = 300

example - work items that the current worker created:

workitem_created_by_worker_id = $current_worker_id$

$prompt_number(“<prompt>”)$

The parameter $prompt_number(“<Prompt>”)$ will produce an edit control labeled with <prompt> on an intermediate page where the worker can provide numeric data. The resolved parameter will not be quoted.

Example $prompt_number(“<prompt>”)$:

workitem_number >= $prompt_number("Enter work item number lower boundary")$

$prompt_string(“<prompt>”)$

The parameter $prompt_string(“<Prompt>”)$ will produce an edit control labeled with <prompt> on an intermediate page where the worker can provide string data. The resolved parameter will be quoted.

Example $prompt_string(“<prompt>”)$:

assigned_to_worker_name >= $prompt_string("Enter a worker name")$

$prompt_lookup(“<prompt>”, “<lookup query name>”)$

The parameter $prompt_lookup(“<prompt>”, “<lookup query name>”)$ will produce a drop-down on an intermediate page where the worker can select a value from the drop-down. The resolved parameter will be the ID of the selected value and will not be quoted. The second parameter must be the name of an existing lookup query. Lookups are customizable. As long as a query is created for the lookup, and the lookup table follows the format of existing lookup tables the lookup prompt parameter will produce a drop-down.

Example $prompt_lookup(“<prompt>”, “<lookup query name>”)$:

Altiris Helpdesk Solution User Guide

76