Author Topic: Searching for Non-Empty Fields Using the Search Builder (Read 1203 times)

IHateForums! · February 04, 2009, 07:10:24 am

I'm looking for how to search for fields which are not null, otherwise known as not empty or having something in them. I figured the search builder would be the best place to do this but can't seem to figure out how. Anyone have any ideas?

Yashodha Chaku · February 04, 2009, 07:30:40 am

Here try http://drupal.demo.civicrm.org/civicrm/contact/search/builder?reset=1

Include contacts where

"Individual" "Gender" "IS NOT NULL"

HTH
-Yashodha

CiviCRM Community Forums (archive)

News:

Author Topic: Searching for Non-Empty Fields Using the Search Builder (Read 1203 times)

IHateForums!

Searching for Non-Empty Fields Using the Search Builder

Yashodha Chaku

Re: Searching for Non-Empty Fields Using the Search Builder