Perform a SQL Where Clause Lookup
Use the SQL Where Clause Lookup to perform complex searches. You create a SQL WHERE clause to use in searching the Vision database.
To search using the SQL Where Clause lookup, complete the following steps:
- Click to display the Lookup list.
- From the Display Type drop-down list, select SQL Where Clause.
- In the Where Clause field, build a SQL WHERE clause using SQL operators.
- Optional: Select Display Search Text.
- Optional: Select Active Only to display only those records whose status is currently Active.
- Optional: Select Pending Accounting Review to display only those records that are pending review.
- Click Search. A list of all records matching your search criteria displays.
-
Complete one of the following actions:
- Click Select All to select all records.
- Highlight only those records you want to display by pressing the CTRL key and clicking Select.
- Use the left arrow and right arrow buttons to navigate through the records that you selected.
- Click the Organize button if you want to save the search criteria for use in the future.