Forum Discussion

carmen922's avatar
carmen922
Copper Contributor
Jun 28, 2023

Filtering for records using multiple values in a enterprise keyword column

Hello community!

 

I have created a enterprise keyword column in my documents list and added values to it. 

 

Currently, when I apply a filter for the keywords, the results will show records with x OR y. 

How can I filter for records with x AND y? 

 

Best regards

  • KotiReddy's avatar
    KotiReddy
    Brass Contributor
    As we have Single Enterprise Keyword column.

    I do not beleive you can have one item with both X & Y. As X and Y are two values for metadata.
    • carmen922's avatar
      carmen922
      Copper Contributor

      Thanks for your input, KotiReddy 

      To clarify, if I wanted to filter for records tagged with Choice 11 AND 12, the results will give me all records with Choice 11 OR Choice 12.

       

      Any ideas?

       

      • KotiReddy's avatar
        KotiReddy
        Brass Contributor

        carmen922 From GUI it may not possible .

        Apply filter for one value and copy url . Using url add another value to filter as below. The filter will be as below.

        AllItems.aspx?origin=createListFromTemplate&FilterField1=Filter&FilterValue1=A&FilterType1=MultiChoice&FilterField2=Filter&FilterValue2=B&FilterType2=MultiChoice

        A and B are my values here.

         




Resources