5

I am learning to filter my data, and I understand how to use the basic operators (e.g. =, OR, AND, !=, less than, more than etc) however there are some operators that are less obvious.

What do the following mean in the query builder operators section?

  • LIKE
  • ILIKE
  • %
  • IN
  • NOT
  • NOT IN

And how might they be used in an expression?

4
  • 1
    Have you had a look at the explanations and examples attached to these expressions? If so, what is left unclear?
    – Erik
    Commented Oct 21, 2019 at 14:26
  • 1
    Where might I find these explanations? They are not in the Query Builder window in QGIS, and I couldn't find anything in the QGIS user guide!
    – Phoebe
    Commented Oct 21, 2019 at 14:31
  • 5
    To be fair the Query Builder of the Provider Feature Filter doesn't have in-build help section (and the help button send me to a non existant page...) but if you go to select feature by expression (or any other place where you could use an expression) you will access the expression builder if you select the Operator menu and click on an operator the description should appear on the right side of the window. these operator should work the same anywhere you use it on QGIS.
    – J.R
    Commented Oct 21, 2019 at 14:35
  • Perfect! Thank you @J.R
    – Phoebe
    Commented Oct 21, 2019 at 14:39

1 Answer 1

5

They all have short explanations when you click on them in the Expression String Builder.

For IN:

enter image description here

3
  • That's not the same window I have in QGIS 3.4!
    – Phoebe
    Commented Oct 21, 2019 at 14:36
  • @Phoebe See my comment on your question
    – J.R
    Commented Oct 21, 2019 at 14:37
  • 1
    The filter tool has a different layout, that is more restrictive. You can get this tool, for example from: the attribute table, and "Select features using an expression". Commented Oct 21, 2019 at 14:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.