Contents Now Platform User Interface Previous Topic Next Topic Filter on multiple string values ... SAVE AS PDF Selected Topic Topic & Subtopics All Topics in Contents Other Share Filter on multiple string values For a string field, you can create a filter that searches for multiple values by creating a comma-delimited list. About this task This feature enables administrators to copy and paste search criteria from a Microsoft Excel spreadsheet into a filter, for example. Note: Do not use the [is one of] operator on fields that contain commas, as the query does not return the expected set of records. Instead, create a filter using multiple [or] statements. Procedure Create the filter with the [is one of] or [is not one of] operator. Depending on the selected field, a choice list or a text box appears. Select one or more of the options by using multiple selection key commands. The choice list remains visible. Alternatively, for text or number fields, type your search options. Separate the options by commas or put each option on a separate line, and do not enclose the selections in brackets. Click Run to filter the list. The filter conditions appear as a comma-delimited string at the top of the results list. Figure 1. Comma-delimited filter string Related TasksCreate a filter in List v2Create a filter in List v3Add related list conditionsRelated ConceptsOR conditionsRelated ReferenceDynamic operators On this page Send Feedback Previous Topic Next Topic
Filter on multiple string values For a string field, you can create a filter that searches for multiple values by creating a comma-delimited list. About this task This feature enables administrators to copy and paste search criteria from a Microsoft Excel spreadsheet into a filter, for example. Note: Do not use the [is one of] operator on fields that contain commas, as the query does not return the expected set of records. Instead, create a filter using multiple [or] statements. Procedure Create the filter with the [is one of] or [is not one of] operator. Depending on the selected field, a choice list or a text box appears. Select one or more of the options by using multiple selection key commands. The choice list remains visible. Alternatively, for text or number fields, type your search options. Separate the options by commas or put each option on a separate line, and do not enclose the selections in brackets. Click Run to filter the list. The filter conditions appear as a comma-delimited string at the top of the results list. Figure 1. Comma-delimited filter string Related TasksCreate a filter in List v2Create a filter in List v3Add related list conditionsRelated ConceptsOR conditionsRelated ReferenceDynamic operators
Filter on multiple string values For a string field, you can create a filter that searches for multiple values by creating a comma-delimited list. About this task This feature enables administrators to copy and paste search criteria from a Microsoft Excel spreadsheet into a filter, for example. Note: Do not use the [is one of] operator on fields that contain commas, as the query does not return the expected set of records. Instead, create a filter using multiple [or] statements. Procedure Create the filter with the [is one of] or [is not one of] operator. Depending on the selected field, a choice list or a text box appears. Select one or more of the options by using multiple selection key commands. The choice list remains visible. Alternatively, for text or number fields, type your search options. Separate the options by commas or put each option on a separate line, and do not enclose the selections in brackets. Click Run to filter the list. The filter conditions appear as a comma-delimited string at the top of the results list. Figure 1. Comma-delimited filter string Related TasksCreate a filter in List v2Create a filter in List v3Add related list conditionsRelated ConceptsOR conditionsRelated ReferenceDynamic operators
