Working with Queries |
To access this tab... |
---|
Click Query Management |
Button | Description |
---|---|
Create Query | Creates a new query. |
Save | Saves the query changes, or the details of the new query. |
Clone | Creates a replica of a query with a new name. |
Delete | Deletes the currently selected query. |
Undo | Undoes the changes made since the last save. |
This section allows you to enter details of a new query and view, or edit an existing one.
Field | Description |
---|---|
Table Name | The table that the query is for. This field is required.
Note: You can create more than one query for a
table.
|
Name of Query | The unique name of the query for the table above, which is made available to the user for selection. This field is required. |
Comments | A description of the query, or any comments relating to it. This field is optional and is for administrator use only. It is not displayed to the user. |
Add Query Conditions | Â |
Select Column | The column to be queried from the table selected. |
Select Operator | The type of comparison operator used in the condition. |
Select Parameter | The parameter type used in the condition: User Input: allows the user to enter their own values. Pick List: allows the user to select a value from a pick list. The values presented in the list are the unique set of values from the column being queried. Use this value: if no user input is needed. The value to use for the parameter is entered in Value/Label for Parameter. The user is not shown the parameter. |
Value/Label for Parameter | The label name for the user input or pick list, or the value to use for the parameter that will be displayed when the query is selected. |
Use the Saved Queries section to select an existing query to view, edit, clone, or delete it.
Field | Description |
---|---|
Table Name | The table that the query is for. |
Query Name | The unique name of the query to be made available to the user for the table selected. |
Modified on | The date on which the last modification to this query was made. |