Filter
Top Products
Chapter 6: User Interface Using Queries
Altiris Helpdesk Solution User Guide 76
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>”)$: