Print      Open PDF Version of Online Help


Previous Topic

Next Topic

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 1/9/2017 Copyright © 2005, 2017, Oracle. All rights reserved. Legal Notices.