CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Unable to search on empty fields using Search Builder
Pages: [1]

Author Topic: Unable to search on empty fields using Search Builder  (Read 1932 times)

BarisArt

  • Guest
Unable to search on empty fields using Search Builder
March 14, 2008, 01:43:46 am
Hi all,

I'm trying to search all users who's e-mail fields is empty.
I cannot achieve this in Search Builder. I tried:

!= ''
= NULL
< 0
= 0

Whatever I try, all inputs are surrounded by quotes, so it will search on: WHERE e-mail IS 'null'
Is there any way to search on this?

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Unable to search on empty fields using Search Builder
March 14, 2008, 02:06:17 am
Yep - the Search is a bit of a weak link. Has been canvassed here too http://forum.civicrm.org/index.php/topic,992.0.html with a wild looking work around and there has been a related issue of not being able to exclude groups here http://forum.civicrm.org/index.php/topic,2686.msg11597.html#msg11597

As Lobo notes elsewhere, the more users call for these issues to be resolved the higher up the list it might rise.

(No pressure Lobo, just spinning off the comments on the 'what isn't working for you' thread)
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

BarisArt

  • Guest
Re: Unable to search on empty fields using Search Builder
March 14, 2008, 04:23:49 am
Thanks for your reply.
I hope this will be solved pretty soon, because we really need it in our organisation..

I'll keep waiting!

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Unable to search on empty fields using Search Builder
March 14, 2008, 12:00:15 pm
Quote from: peterd on March 14, 2008, 02:06:17 am
As Lobo notes elsewhere, the more users call for these issues to be resolved the higher up the list it might rise.

(No pressure Lobo, just spinning off the comments on the 'what isn't working for you' thread)

hey, you forgot to mention some other things which i mention repeatedly :) i.e. the community helping out with and stepping up development/docs/support/sponsorship etc, like the post here:

http://forum.civicrm.org/index.php/topic,2609.msg11520.html#msg11520

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Unable to search on empty fields using Search Builder
March 14, 2008, 12:02:20 pm
Quote from: BarisArt on March 14, 2008, 04:23:49 am
I'll keep waiting!

If you have programming skills, you might want to take a look at CRM/Contact/BAO/Query.php and try adding support for the below. We'd be happy to help you out / answer questions on IRC

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Unable to search on empty fields using Search Builder
March 14, 2008, 01:00:32 pm
Quote from: Donald Lobo on March 14, 2008, 12:00:15 pm
hey, you forgot to mention some other things which i mention repeatedly :) i.e. the community helping out with and stepping up development/docs/support/sponsorship etc, like the post here:

http://forum.civicrm.org/index.php/topic,2609.msg11520.html#msg11520

lobo

which is the sheepish smiley face
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Unable to search on empty fields using Search Builder

This forum was archived on 2017-11-26.