GOAL: To find the syntax for searching for a field with a NULL value in a view search bar.
So for example I want to perform the equivalent of
FIELD NAME = “”
in the search bar of a view using FTSearch.
Can anyone help, I cant even find documentation for doing this. I stumbled across the undocumented “IS PRESENT” which is the exact opposite of what I need.
Subject: Is a full text search for a NULL value possible?
http://www.alanlepofsky.net/alepofsky/alanblog.nsf/dx/searching-for-blank-fields
Subject: RE: Is a full text search for a NULL value possible?
THANK YOU VERY MUCH! Works beautifully.
Subject: RE: Is a full text search for a NULL value possible?
NOT is the word that turns the exact opposite of what you need, into what you need.