Problem with IS NULL operator in search builder

[EdP]

I was trying to find contacts who were not in any group. I used search builder and searched for "individuals" where "Group" "IS NULL".
I got an error saying that I should remove the text from the box which specifies the search criteria. I hadn't put any in. You get the same outcome on the Joomla demo site.

It may be that this is the wrong way to search for this criteria - but even if it is, the error message is unhelpful.

Its a minor thing, but unexpected and given the error message looks more like a bug than user error (for once!)

[Donald Lobo]

would be great if you can investigate and submit a patch to fix this issue

thanx

lobo

[est]

I have the same problem on Drupal site. Also IS NOT NULL operator does not work in search builder.

It says:

Code: [Select]

Please correct the following errors in the form fields below:
    Please clear your value if you want to use IS NULL operator.

[Donald Lobo]

can you investigate and submit a patch that will handle both IS NULL and IS NOT NULL

thanx

lobo

[greache]

Any progress on this ... I can't search for people without a tag / group either ... sry I can't even start to fix it with a patch 

[Donald Lobo]

no. if important to you, consider hiring someone from http://civicrm.org/professional/ to work on a patch / improve search builder functionality

lobo

[moosed]

I don't know if you solved this.  I've added this patch to my query.php file, and selecting EMAIL IS NULL or EMAIL IS NOT NULL works using the Search Builder.

civiCRM 3.2.1
Joomla 1.5.13
Community Builder 1.2.3

<JOOMLA WEBROOT>/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/query.php

Code: [Select]

*** query.php 2010-09-18 20:11:20.833584429 -1000
--- query.php2 2010-09-18 20:17:02.413584328 -1000
***************
*** 2576,2581 ****
--- 2576,2585 ----
              } else {
                  $value = "'$value'";
              }
+         }
+         if ( $op == 'IS NULL' ||
+              $op == 'IS NOT NULL' ) {
+              $value = null;
          }
 
          $this->_tables['civicrm_email'] = $this->_whereTables['civicrm_email'] = 1;

Let me know if you found a better solution!

Doug

[b0b_z]

I'm having the same problem in Civicrm 4.1.2/Drup with the same search

Anyone figure a workaround?

[Donald Lobo]

Thanx to the great folks at New York State Senate, a lot of fixes and improvements for search builder are coming in 4.3. However u'll need to wait for this release which is likely to be in october or so

lobo

[petednz]

Yay for the NYSS and those working with them ;-)

[Donald Lobo]

now, all we need to find are 2-3 more organizations who are good community contributors and participants like them.

petednz: u need to work on the greens party worldwide and get them to replicate the NYSS model

lobo

[Owen]

Good news indeed, thank you NYSS