Using the Query-by-Example Line

You can use the query-by-example line to search for records by a grid column. For example, if you are searching for a person by name, enter all or part of the name in the query-by-example line directly above the Alpha Name column in the grid. The information that you enter in the query-by-example line must be a valid value for the column. If it is not, the system does not find a match. You cannot enter values in the disabled (grayed-out) columns because these columns do not allow searches. Some query-by-example lines work differently. On some forms in the Tools setup applications, tabbing to the end of a line after filling in one or more fields achieves the same result as clicking the Find button.

On any Find/Browse form, type the characters on which you want to search in the corresponding column of the query-by-example line, and then click Find. For example, on Address Book Revisions (P01012), type all or part of the name of the individual you are searching for in the Alpha Name column of the query-by-example line, and then click Find. The record that matches the query criteria appears in the grid.