12.1p: How to trigger OR manually in allowFilterExpressions: true ListGrid

[Blama]

Hi Isomorphic,

I'm wondering how to trigger OR, like in column population here (v12.1p_2023-04-18) for other columns like in the screenshot column code.
I just entered "QA or AN" and this seems to filter for

{
                fieldName:"countryCode",
                operator:"iContainsPattern",
                value:"QA or AN"
            },

as seen when you enter countryList.refreshData() in the Developer Console "Evaluate JS Expression" to trigger a server fetch in Developer Console "RPC Tab".

Thank you & Best regards
Blama

[Isomorphic]

Logical operators aren't supported in text fields because " or ", for example, is valid as part of a text filter-value.

You can achieve "QA or AN" with "=(QA|AN)", which will produce an inSet criterion.

We'll look at making some doc clarifications in this area and get back to you.

[Blama]

Hi Isomorphic,

thanks, that makes sense and in area for example entry 450 or 11000 is working as expected.
Also =(QA|AN) in text fields is working as expected.

I found a problem with allowFilterExpressions though and will make a new thread.

Best regards
Blama