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) »
  • Problem with Search Builder
Pages: [1]

Author Topic: Problem with Search Builder  (Read 1116 times)

vshura

  • I post occasionally
  • **
  • Posts: 59
  • Karma: 1
  • CiviCRM version: 4.6.0
  • CMS version: Wordpress 4.1.1
Problem with Search Builder
September 01, 2008, 05:57:25 am
Hi.

I've a problem with the Search Builder which I can't figure out.  I had a smart group composed which searched for the following:

Code: [Select]
Newsletter Mailout (smart group)
    * City !=   ... AND ... Contact Type - 'Individual'   ... AND ... Involvement = Mailing List Request
    * OR
    * City !=   ... AND ... Contact Type - 'Individual'   ... AND ... Involvement = Friend
    * OR
    * City !=   ... AND ... Contact Type - 'Individual'   ... AND ... Involvement = Friend 2
    * OR
    * City !=   ... AND ... Contact Type - 'Individual'   ... AND ... Involvement = Friend 3
    * OR
    * City !=   ... AND ... Contact Type - 'Individual'   ... AND ... Involvement = Friend 4
    * OR
    * City !=   ... AND ... Contact Type - 'Individual'   ... AND ... Involvement = Friend 5
    * OR
    * City !=   ... AND ... Contact Type - 'Organization'   ... AND ... Involvement = Organisation

I realised that I need to change this to take people out of this emailing list who have ticked the 'Do not mail' box, so proceeded to add that criteria:

Code: [Select]
Newsletter Mailout (smart group)
    * City !=   ... AND ... Do Not Mail != 1   ... AND ... Contact Type - 'Individual'   ... AND ... Involvement = Mailing List Request
    * OR
    * City !=   ... AND ... Do Not Mail != 1   ... AND ... Contact Type - 'Individual'   ... AND ... Involvement = Friend
    * OR
    * City !=   ... AND ... Do Not Mail != 1   ... AND ... Contact Type - 'Individual'   ... AND ... Involvement = Friend 2
    * OR
    * City !=   ... AND ... Do Not Mail != 1   ... AND ... Contact Type - 'Individual'   ... AND ... Involvement = Friend 3
    * OR
    * City !=   ... AND ... Contact Type - 'Individual'   ... AND ... Involvement = Friend 4
    * OR
    * City !=   ... AND ... Contact Type - 'Individual'   ... AND ... Involvement = Friend 5
    * OR
    * City !=   ... AND ... Contact Type - 'Organization'   ... AND ... Involvement = Organisation

This 'Do not Mail != 1' should be in all lines of the search above, but when I got to this point (i.e. the point in the second search above) it would not let me add another search field when I clicked the 'Another search field' in the green/blue box for the 'Friend 4' search section.  It simply reloaded as if it would allow this, but no new line appears.  It just stays the same as when I click 'Another search field'.

Any ideas?  I'm using CiviCRM 2.0.5 and Drupal 5.8.  I use Firefox 3.0.1 and but it's the same on IE7.

Thanks,
VS.

P.S. Is there a way to use the Search Builder to search for all people with non-blank addresses and then add them according to the custom field 'Involvement'.  I realise you can do it with smart groups, but it'd be nice to be able to do it all in one search.  Particularly in order to explain it to less-techie people.  I mean something like

Code: [Select]
(City !=   ) ... AND ... (Contact Type - 'Individual'  ... AND ... ((Involvement = Mailing List Request OR Involvment = Friend OR Involvement = Friend 1 OR Involvement = Friend 2 etc... ))  etc.

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Problem with Search Builder
September 01, 2008, 09:01:39 am
Can u replicate the same on http://drupal.demo.civicrm.org ?

Quote
P.S. Is there a way to use the Search Builder to search for all people with non-blank addresses and then add them according to the custom field 'Involvement'.

You can use "IS NOT NULL" introduced in Search Builder in 2.1.

hth
-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

vshura

  • I post occasionally
  • **
  • Posts: 59
  • Karma: 1
  • CiviCRM version: 4.6.0
  • CMS version: Wordpress 4.1.1
Re: Problem with Search Builder
September 03, 2008, 09:54:37 am
I could try, but it doesn't seem to be working right now...

I'll try again later.

VS

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: Problem with Search Builder
September 03, 2008, 10:57:53 am

demo is now fixed

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Problem with Search Builder

This forum was archived on 2017-11-26.