Creating Queries
Adding filters
There are a number of ways to enter values. If you know the value, you can simply enter it in the space provided.
If you are unsure of the values that are available for a particular column,
click
to see the following three options:
- Actual values: Displays a list of all of
the values that are available in the selected column.
- Possible values: Displays a list of the values that exist for the selected column,
but may not be in the actual subset. For example, if you choose
"Employee Gender" as your column, and you choose Actual values you may see only a value for "male" if your subset contains
only males. However, by selecting Possible values you can see that both male and female values exist for that column.
Not all columns will have a list of possible
values. Columns like "Gender" or "Ethnicity" will display a list of possible values, but a column such as "Employee ID" will not.
- User prompts: Displays a list of existing user prompts which can be used for that column based on its data type.
If you select this option, you will prompted for the value when the table is generated;
therefore, you have no permanent value stored in your query. You can enter a different value every time you run
the query, without having to change the query itself. For more information, see Creating user prompts.
- Existing columns: Displays a list of existing columns which are available to be used
in the filter. After you select a column and click OK, the column name is displayed
in the Value field with an @ preceeding the column name, which indicates that the value
is a column.
Return to Filter Selection.