Enter a WHERE Clause

You can search the  database for particular records via entering a SQL WHERE clause in the Where Clause dialog box.

Note: A few  applications consist of only one page; therefore, they do not have a List tab. With the exception of Bookmarks, one-page applications have a Search Toolbar with the same search options found on the List tab. In those applications, the system displays the search results on the application page.

To enter a WHERE clause:

  1. Open an application.

  2. From the List tab, click Advanced Search. The system displays the Advanced Search menu.

  3. Click Where Clause. The system displays the Where Clause dialog box.

  4. In the Current Query field, enter the SQL WHERE clause. You can also perform the following:

  5. Select a query from the View/Manage Queries dialog box. The system displays this query in the Current Query field. You can modify the displayed query.

  6. Search for a record using the More Search Fields dialog box. The system displays this query in the Current Query field. You can modify the displayed query.

  1. Click one of the following buttons:

  2. Click OK to perform a search using the displayed query.

  3. Click Cancel to return to the List tab without performing a search.

Note: You can save this query via the Save Current Query dialog box.

See Also

Search for Records

Save a Current Query

View/Manage Queries

Advanced Search Tips