Quick tip: FTSearch for field is blank

by Bernd Hort,
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

Sie haben Fragen zu diesem Artikel? Kontaktieren Sie uns gerne: blog@assono.de

Do you want an individual solution? Contact us

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.

We don’t sell your data. 100% guaranteed. See: Privacy Policy
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
Technical department: +49 4307 900 403
Marketing department: +49 4307 900 402

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