Filter field with many values in UI Builder

[daikhi haithem]

Hello, I would like to know what the best solution is for filtering on fields with many values in UI Builder

[Dibyaratnam]

Can you elaborate on your use case, its not quite understandable

[AbinC]

Hi @daikhi haithem ,

• Home
• Technical Documentation
• Release Notes
• API Implementation
• Accessibility
•  
• Abin Chacko

Filter

Table of contents

ExpandCollapse

• Configure user experiences
  • Configure UIs and portals
    • Next Experience UI
    • Workspace UI
    • Working in Core UI
      • Core UI
      • Working in the classic environment
        • Lists in the classic environment
          • List fields
          • Configure and use list functions
          • Activity streams in list view
          • Search a list
          • Grouped lists
          • Filters and breadcrumbs
            • Quick filters
            • Filters
              • Create a filter in List
              • Add related list conditions
              • OR conditions
              • Filter on multiple string values
              • Dynamic operators
            • Save and use filters in a list view
            • Filter admin functions
            • Encoded query strings
          • Methods for list edits
          • Personal lists
        • Forms in the classic environment
      • Common UI elements
      • Browser support
      • Core UI keyboard shortcuts
      • User interface configuration
    • Content Management System
    • Service Portal
  • Adoption services
  • Personalize your experience

Table of Contents

Filter on multiple string values

• Release version: 
  XanaduYokohamaWashington DCVancouver

  Xanadu
• UpdatedAug 1, 2024
• 2 minutes to read

For a string field, you can create a filter that searches for multiple values by creating a comma-delimited list.

Before you begin

Role required: admin

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

1. 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.
2. 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.

   
3. Click Run to filter the list.
   The filter conditions appear as a comma-delimited string at the top of the results list.

   Comma-delimited filter string

   Please do mark helpfull and also mark solution given as it will help me to grow in community 

   Thanks,

   Abin