When you are verifying fields or table cells, it can be useful to search master data using field-related expressions and insert one of the hits to the assigned field.
Use this procedure:
Using Verification, select > (or use the function key ).
The dialog is displayed (but with a title that matches the saved query).
In the column, type a search expression for each desired parameter and click .
If is selected in the dialog, these wildcards can be used in the search expressions:
or % | Zero or more characters. Example search of names: ROB* or ROB% returns all data sets in which Name begins with ROB. |
One character. Example search of names: ROB?ER* returns all data sets in which Name begins with RO, followed by any single character, followed by ER, followed by zero or more characters. |
Note: When searching, it is important to know whether your database is configured for case sensitivity (distinguishing between uppercase and lowercase letters). Microsoft SQL Server databases are usually not case sensitive. IBM DB2 and Oracle databases are often case sensitive.
To delete all values and start a new query, click .
To transfer the information to the document's fields, double-click an entry in the box.