You can perform an advanced search using the More Search Fields and Enter Where Clause dialog boxes. These dialog boxes are accessed via Advanced Search on the List tab.
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.
You use the More Search Fields dialog box to search for a particular records using additional fields. The number of fields available to perform a search varies for each application.
Tips:
To narrow the number of search returns, enter values in multiple fields.
If there are no rows that match your search criteria, the system displays a "...No rows to display..." message in the List tab table window. Reopen the More Search Fields dialog box and click Clear. The system clears the values you entered for the search.
Fields on the More Search Fields dialog box that are represented by check boxes in the application require you to enter a Y (selected checkbox) or N (cleared check box) value.
You can search the database for particular records via entering a SQL WHERE clause in the Where Clause dialog box.
Note: To perform advanced queries, you should be familiar with both Structured Query Language (SQL) and the database. Constructing SQL queries is more commonly performed by system administrators and database administrators, and is not covered within the scope of the help system.
Tips:
You can use wildcards and operators when writing SQL queries for searching the database.
Use the underscore (_) or question mark (?) to substitute for a single character in the specified query.
Use the asterisk (*) or percent sign (%) to substitute for any number of characters (zero, one, or a string of characters in the specified query).
You can select a query from the View/Manage Queries dialog box. The system displays this query in the Current Query field of the Where Clause dialog box.. You can modify the displayed query.
You can search for a record using the More Search Fields dialog box. The system displays this query in the Current Query field of the Where Clause dialog box. You can modify the displayed query.