en · de

Quick tip: FTSearch for field is blank

by Bernd,
assono GmbH, Standort Hamburg,


As Andre Guirard pointed out in his Blog a fulltext search for an empty field is possible. The syntax to search for a none empty field is
[Feldname] is present

If the aim is to search for a empty field the search query has to be provided with a NOT. So if you want to search for a todo with no one assigned to the query would be
[Form] = "Todo" AND NOT [AssignedTo] is present
if the form is "Todo" and the person assigned to is in the field "AssignedTo".

Technical article

You have questions about this article? Contact us: blog@assono.de

Sie wollen eine individuelle Beratung oder einen Workshop? Read more

More interesting entries

Any questions? Contact us.

If you want to know more about our offers, you can contact us at any time. There are several ways to contact us for a non-binding first consultation.

assono GmbH

Location Kiel (headquarters)
assono GmbH
Lise-Meitner-Straße 1–7
24223 Schwentinental

Location Hamburg
assono GmbH
Bornkampsweg 58
22761 Hamburg

Phone numbers:
Human resources department: +49 4307 900 407
Marketing department: +49 4307 900 411

E-Mail adresses:
contact@assono.de
bewerbung@assono.de