CiviCRM Community Forums (archive)

Our organization offers discounts on the purchase of Subaru vehicles for our members. In order to get the discount we collect some basic information and place a request into Subaru.

To track each request I created a Custom Data Group used for Contacts, and since each contact may have multiple requests I set the Custom Data Group to allow multiple records. I created the Custom Fields including a "Request Created Date" and "Request Processed Date". All is well and we are tracking requests just fine.

Now I need to search and find contacts which have unprocessed requests -- these would be requests with a NULL "Request Processed Date". I first went to search builder but the custom data fields do not appear in the list of fields associate with the individual, household, or organization record types.

So I went to the Advanced Search where the custom fields do appear and are searchable. I can't search for a NULL date in Advanced Search (or haven't figured out how), only a date range, so I searched for all contacts with custom field "Request Created Date" which fell within a certain range hoping to find the four contacts where I had created requests.

The search returned 140,000+ records.

Would someone please help me understand the behavior of the search in this instance. Is this somehow a product of searching on a field in a Custom Data Group which allows multiple records?

I am running CiviCRM 3.0.0.