3

Operators for searching one/several texts in the field filter (Boolean)

From time to time you need to search for several texts in a table column at the same time or you want to exclude certain texts from the search. To do this, you can use various operators that are inserted in the "Filter" field of the column. Upper and lower case is generally ignored.

 

like => must be placed before each condition
or => outputs what matches one of the conditions
and => outputs what matches all conditions
not => inverts the respective condition
( ) => parenthesis // important for ordering the conditions (order of resolution, see 5. & following)

A few usage examples follow.

Table:

 

1. like "grün"
    all records, whose text contains "grün"
    => "Grünkohl", "Grünspan", "Immergrüne Eibe"

2. like "span" or like "buch"
    all records whose text contains "span" or "buch".
    => "Buche", "Buchweizen", "Grünspan", "Spanisches Moss"

3. not like "kohl"
    all records whose text does not contain "kohl"
    => everything except "Blumenkohl", "Grünkohl"

4. like "weizen" and not like "gmo"
    all records whose text contains "weizen" but not "gmo"
    => "Buchweizen", "Weizen".

5. (like "distel" or like "weizen") and not like "gmo"
    all records whose text contains "distel" or "weizen" but not "gmo"
    => "Buchweizen", "Riesendistel", "Weizen"

6. (like "distel" or like "weizen") and (like "riesen" or like "buch")
    all records whose text contains "thistle" or "wheat" but also "riesen" or "buch"
    => "Buchweizen", "Riesendistel"

7. (like "span" and like "moss") or (like "weizen" and like "gmo")
    all records whose text contains "span" and "moss", or "weizen" and "gmo".
    => "Spanisches Moss", "Weizen (GMO)"

With a little experimentation you can build virtually all possible combinations of search filters, see the table as .csv in the attachment.

Have fun!

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Thanks a lot Ben, it works really well.
    I had never thought of putting my text in quotes and was wondering how to do this kind of complex search.
    It's really good that the Ninox people are giving this kind of information on the forum, well done!

    Like 1
Like3 Follow
  • 3 Likes
  • 4 mths agoLast active
  • 1Replies
  • 81Views
  • 4 Following