Setting conditions for an inquiry
You can set conditions to limit the data that appears in an inquiry. For example, you may want to see only active projects on a Project inquiry.
You set conditions for an inquiry by setting conditions for one or more of the columns on that inquiry.
| Note: | When you view an inquiry by clicking a link to it from another inquiry, you can temporarily set conditions for it but they are not saved. Instead, access the inquiry from the Inquiry menu and then set conditions for it, as described in the following instructions. You can also set the conditions on the link you use to open the inquiry. |
- From the Inquiry menu, select the inquiry you want.
- Click
. - Click the Conditions tab.
- In the field that contains
text asking you to select a column, click
and select the column on which you want to
set a condition. Even if a column does not appear on the inquiry, you
can still set conditions for it that affect the information that appears
on the inquiry.
| Note: | You can select a regular column or a key field column. |
- Two fields appear to the right where you set the conditions for the column you selected.
You set conditions much in the same way you write a formula. You define a relationship between the column you selected and another value or column. Begin by exploring the available options in both of these fields.
- In the middle field to the right, select an operator which expresses the relationship you want to establish between the column you selected and the value or column in the last field on the right.
- In addition to the standard mathematical operators, you may also find these operators useful:
| Operator | Description |
|---|---|
|
One Of |
Use this operator to select more than one value. In the field at the far right, type the values separated by a semicolon ; For example, if your column is Status and you want to show all invoices that have a status of active or preliminary, you enter the following in the field at the far right: active;preliminary |
|
Not One Of |
Use this operator to select all but a specific value or values. In the field at the far right, type the values separated by a semicolon ; For example, if your column is Status and you want to show all invoices except those that have a status of inactive or preliminary, you enter the following in the field at the far right: inactive;preliminary |
|
Matches Pattern |
Use this operator to show only data that fits a certain pattern. When typing a value in the field at the right:
For example, to show all invoice IDs that contain 200 in the same position as this ID: 07-200-090G1, you enter %200%. |
|
Within Last X Days |
For date fields, use this operator to show only data for a date range based on the current date. In the field at the right, type the number of days, as follows:
For example, you type one of the following in the field at the right:
|
|
Not Within Last X Days |
For date fields, use this operator to exclude data for a date range based on the current date. In the field at the right, type the number of days, as follows:
For example, you type one of the following in the field at the right:
|
|
Is Current User |
For employee key fields, use this operator to show data pertaining only to the current user. |
- In the last field on the right, review the values that are available and make a selection.
- You can set additional conditions, as needed. Notice that a selection field now appears on the next row for you to set another condition. The order of the conditions does not matter, as all conditions are always applied regardless of order.
- To delete a condition, click the Delete button at the far right of the condition.
To save the conditions, click OK.
See also
