Mapping more than one database value to a displayed value

If you map more than one database value to the same displayed value, the client searches the database by using all of the database values. For example, assume the following database value and displayed value mappings:

Assume that a folder field named Report ID is mapped to an application group field named reportid and that the application group field contains the mappings from the table above. The Windows client displays a folder search field with the options Quarterly Reports and Year End Report. If the user selects Quarterly Reports, the client queries for documents that contain a database value of 101, 102, and 103.

Note: When mapping more than one Database Value to the same Displayed Value, the database values should not contain the wildcard character (%) because the search is performed for one of the database values only. For example:

If the user selects Quarterly Reports, only one of the database values that are mapped to Quarterly Reports are used in the search that is performed by the client. IBM recommends that you never specify a wildcard in this case because the search might not return the expected results.