How to select all element with value1 and value2 in a single field

[Antoine553]

Hello,

I have been asked about a way to select elements based on the presence of multiple values in a single field for the same element. They managed to write something in the search bar of a filter pane to select all elements having Value1 AND Value2 :

Dataset :

Element	My_Field
Test1	Value1
Test1	Value2
Test1	Value3
Test2	Value1
Test2	Value3
Test3	Value1
Test3	Value2
Test3	Value3

Active selection in the filter Pane :
Test1 and Test3

I'm having a hard time finding out how to write this.

[brunobertels]

Hi 

Try to use concat() function 

[jamesaa]

---

@Antoine553 wrote:

Hello,

I have been asked about a way to select elements based on the presence of multiple values in a single field for the same element. They managed to write something in the search bar of a filter pane to select all elements having Value1 AND Value2 :

Dataset :

Element	My_Field
Test1	Value1
Test1	Value2
Test1	Value3
Test2	Value1
Test2	Value3
Test3	Value1
Test3	Value2
Test3	Value3

Active selection in the filter Pane :
Test1 and Test3

I'm having a hard time finding out how to write this. locksmith services

---

To select all elements with both value1 and value2 in a single field, use a query that checks for both values.