Hi,
I want to filter the list which contain some items.
For example: i have Item A, Item B, Item C, Item D,Item E
and i want to use the filter function which only filter out Item A, Item B, Item C only.
In filter site, it had "Contain" operator, and i want to know how to use this operator to filter the item i want?
AND Item IS CONTAINS Item A, Item B, Item C?
Or i can use IN operator?
The "Contains" operator is used to search for a
specified pattern in the field values. It uses the SQL LIKE operator. If you want to search for any of a list of values you should use the IN operator which uses the SQL IN operator. hth
If use IN operator, what is the proper way to write it in "Red Circle Column" as show in the attached picture below:
Comma delimited, without brackets.
is it --> Food,Drink
I try it, but the filter doesn't work?
Can you write down the correct form?
If it is select field, try the indices instead of the labels. So if the options are
Food
Music
Drink
Misc
and you want to search for Food or Drink, try 1,3
hth
Hi Itamar,
I had tried it, the indices doesn't work too.
1,3 --> not work
Food,Drink --> not work
Food --> This work
If i just add in Food, the filter work.
Is there any coding issues?
Maybe. You open a tracker issue in the Set: Dataform component for that. In the meantime you can try filters such as the following:
OR Categories Content IS Equals Food
OR Categories Content IS Equals Drink
hth
Hi,
Ya, end up i used this type of filter. It caused me a lot of time. Since i had 20 item, so i had to key in one by one.
Hopefully this issue will be solved
