How can I put an "or" criteria into the equal/contains field (screenshot attached) | Community
Skip to main content
TinoMe
Level 2
Feb 7, 2022 4:42 PM UTC
Question

How can I put an "or" criteria into the equal/contains field (screenshot attached)

Hi community,

I am trying to find a way to set up a filter which is capable of filtering for multiple numbers within one field. The attached shows what I am planning to do.

The 1500 in the top one is supposed to be the same through all combinations but the 1975, 1160 and 2765 should be changed.

Can someone tell me how I can seperate those terms and have them set up as "or" conditions without putting and "AND" condition for each combination?

Thanks in advance

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

4 replies

RandyRoberts
RandyRoberts
New Participant
Feb 7, 2022 11:48 PM UTC

A lot of Javascript operators are the same as text mode. Usually I try them first, some work great and some don't.

https://www.w3schools.com/js/js_operators.asp

Here is what you're looking for though.

This will probably help too.

Translate
    TinoMeAuthor
    Level 2
    Feb 9, 2022 12:24 PM UTC

    Hi Randy,

    also much thanks for your input. I never looked at those tables and expression lists. Will pick it up right away.

    Thanks!

    Translate
    Tammy_Hall-Johnson
    Tammy_Hall-Johnson
    Level 2
    Feb 7, 2022 9:37 PM UTC

    Try in Text Mode using || for your Or Statement. We just did this... (status=”New” || “INP”)

    Translate
      TinoMeAuthor
      Level 2
      Feb 9, 2022 12:23 PM UTC

      Hi Tammy, thank you for your quick answer. I tried it out but it seems like this "or" statement is somehow not working in the reporting filter!?

      Could you tell me where you used this?

      I tried to replicate the standard mode "or" statement in textmode but even that does not work for me.

      Maybe it is also the fact that I am filtering for a free flow text field and you used the build in filters?

      I will try to find sth out.

      Thank you very much for your help!

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...