| Print Open PDF Version of Online Help

#### About Searching on Multi-Select Picklists You can search and query on all of the values of a multi-select picklist field. A multi-select picklist is a picklist from which you can select multiple values when entering record information. Multi-select picklist fields are supported as columns in target search results and in target search filter criteria. The following list shows how the multi-select picklist values in the filter criteria and the filter condition determine which records are found in the search: Contains all values. A record is found if all the specified filter values match the multi-select picklist values of a searched record. Contains at least one value. A record is found if any of the specified filter values match the multi-select picklist values of a searched record. Contains none of the values. A record is found if none of the specified filter values match the multi-select picklist values of a searched record.

Published August 2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.