Author Topic: Smart Groups based on Search Builder queries fail (after upgrade to 2.2.7) (Read 1369 times)

rjlang · July 22, 2009, 12:16:08 pm

Hi,
We just upgraded our CiviCRM from 2.0.6 (under Drupal 5) to 2.2.7 (under Drupal 6). All contacts, groups, etc., apparently came through OK. However, we had several Smart Groups built from Search Builder queries that used to work but now consistently display only a single record in their Members.

One example is a list of all organizations with Country(Main)=Canada, for which we have 7 contacts in our db. If I click on the Members link for this Smart Group, it only lists one of them.

Oddly, if I click on "Edit Smart Group Criteria," then on the resulting page all 7 records are shown (and "Canada" is highlighted in red, if that says anything). And if I then select the "Update Smart Group" command from the popup, updating apparently proceeds OK; but then next time I try to check the membership of the group, it again lists only one member.

Creating a new Smart Group using the same Search Builder query displays the same symptoms as the imported Smart Group -- lists all 7 records when I edit the Smart Group criteria, but only lists one record in its member list.

And, if I instead use the Advanced Search functions to build the Smart Group (selecting Country(Main)=Canada from the available menus), that Smart Group works. It's only the Search Builder Smart Group that doesn't work. (Unfortunately, some of our smart groups need the advanced Boolean logic of Search Builder.)

Can anyone offer any suggestions?

Thanks,

Robert

Dave Greenberg · July 23, 2009, 10:00:43 am

Robert - My first thought was that this might be a smart group caching issue. But given that building a new smart group hits the same problem I'm suspicious that this might be a regression bug in 2.2.7. If you can recreate the problem behavior on the public demo (link above) - then please file an issue against 2.2.7 including detailed steps to replicate. thx!

dharmatech · July 28, 2009, 03:35:49 pm

Hi,
We upgraded our production dharmatech.org site from 2.2.6 to 2.2.7 last week and noticed some smart groups built from search builder does not return the correct results. Going to the smart group in question, select members, and click on "edit search criteria" doesn't return the correct results. Running the exact query from advanced search and the same query again from search builder in 2.2.7 returns the correct results. Just letting you know that we are seeing the same behavior. You are not alone and we've reported the bug.

SoFlaWeb · August 23, 2009, 08:03:08 pm

i just want to add that we too are experiencing a similar issue.

We are testing some smartgroups on civicrm 2.2.8 on Drupal 6.

We have created a smartgroup of REGULAR membership type with a status of NEW or CURRENT.
This allowed us to create a member directory that will only display members who are current (meaning they have paid). Since the membership registration form is public, we have limited this group to only display members of the smartgroup.

When we add a new member they don't show in the directory.
When I go to MANAGE GROUPS and then VIEW MEMBERS, I don't see the new additions.
When I go to EDIT SMARTGROUP SEARCH CRITERIA, then I see the new records, however it still doesn't update my public member directory.
After several hours of testing we realize that we have to manually update the smart group in order for it to see the new records . This kind of defeats the purpose of this type of group.
I am glad to see that this is a bug and someone is already on it.

Thanks.

BTW. I would be interested to know if we are doing this in the correct manner. Is the only way to limit our public member directory by using a group?

Thanks again. CiviCRM Rocks!!!

Donald Lobo · August 24, 2009, 05:48:16 am

This is a bug. can u please file an issue for this

thanx

lobo

devfloppy · August 31, 2009, 06:01:47 pm

I'm also having the same issue with civicrm 2.1.6. Did anyone post an issue for this yet? I didn't see a reply. I havn't looked at the code for civicrm but I can offer my assistance creating a patch if need be. Any pointers in a good place to get started would help.

Donald Lobo · August 31, 2009, 10:05:45 pm

check: http://issues.civicrm.org/jira/browse/CRM-4806

on further investigation we figure this is out due to a bug fix in the custom search (include/exclude groups, tags). The DT folks will be submitting a patch for this we hope

and fixing the behavior of the custom search

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: Smart Groups based on Search Builder queries fail (after upgrade to 2.2.7) (Read 1369 times)

rjlang

Smart Groups based on Search Builder queries fail (after upgrade to 2.2.7)

Dave Greenberg

Re: Smart Groups based on Search Builder queries fail (after upgrade to 2.2.7)

dharmatech

Re: Smart Groups based on Search Builder queries fail (after upgrade to 2.2.7)

SoFlaWeb

Re: Smart Groups based on Search Builder queries fail (after upgrade to 2.2.7)

Donald Lobo

Re: Smart Groups based on Search Builder queries fail (after upgrade to 2.2.7)

devfloppy

Re: Smart Groups based on Search Builder queries fail (after upgrade to 2.2.7)

Donald Lobo

Re: Smart Groups based on Search Builder queries fail (after upgrade to 2.2.7)