Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

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

    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

    Code:
    {
                    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

    Click image for larger version

Name:	No OR filter.PNG
Views:	130
Size:	11.5 KB
ID:	270024


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

    Comment


      #3
      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

      Comment

      Working...
      X