Searching for NULLs

EmailFacebookGoogle+LinkedInTwitterShare

Sometimes in EPDM you want to find all files that do not have a value for a field in the datacard.

Your first thought may be to use a datacard to search but that doesn’t work because any fields left blank are not considered in the search criteria.

You have to search on the variables. Set it up like this:

variable

(The “value” column is empty.) For this example, all files that do not have a value for “Title” will be found in the search.

Tip within a tip…you will likely want to uncheck “Search in all versions” otherwise you may get many more hits that you expect. (Variables in version “1” of most of your files is probably blank.)

NotAllVersions