Skip to Content

Select Not equal to versus Exclude Single Value

Hello.

Can somebody explain what is the difference between the filters used in the picture? Select Not equal to versus Exclude Single Value

Thank you.

select-exclude.png (16.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 10, 2020 at 05:22 PM

    As a single line they'll give you the same result (not sure if one is more efficient than the other). If you start putting in multiple lines then it matters.

    The "Select" options build your list, and will add any item that matches any of those lines. So if the field I'm looking at is names of fruit and I select ≠ "banana" as well as ≠ "orange" it would give me everything because bananas will be included when looking for items that aren't oranges and vice versa.

    "Exclude" then goes through the list that Select made (or just everything if you left the Select list blank) and removes what matches. Adding multiple exclude = would work as you probably expect it to, but you can hit the same issue as above with exclude ≠. Only this time the overmatching would dump all your results and return nothing.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.