CiviCRM Community Forums (archive)

I wanted to set up a smart group that would include contacts at a group of a couple hundred of specific addresses, and didn't want to have to enter all of the criteria using Search Builder.

I went in and set up the first few, and then using phpmyadmin, found the appropriate record in the  civicrm_saved_search table. I edited the where_clause there to include the full list of criteria.

When I search on that smart group through advanced search) the old smaller record set is return. When I go int to edit criteria via manage groups, it is still showing me the old search criteria with the serach builder profile. I have been back in to civicrm_saved_search table through phpmyadmin several times, and the new criteria are definitely saved.

I played around a bit with the smart group cache, and watching it in phpmyadmin I am confident that civicrm_group_contact_cache has been flushed, and then gets repopulated, but the old search criteria are still the ones being used.

Any idea why civiCRM would be ignoring my updated where_clause in civicrm_saved_search? Is there a second place where this criteria needs to be updated?

It wouldn't be the first time I was incoherent!

I checked in civicrm_group, and the where_clause (and select_tables and where_tables) refers to "civicrm_group_contact_cache_87".

civicrm_group_contact_cache was again blank, and after searching on that smart group, was again repopulated using the old criteria.

What I find most confusing is that the smart group is still recalling the initial criteria I set up, even though those no longer appear in civicrm_group. If I did get something wrong with the code, I would think I'd get an error, not a reversion to the old criteria which is no longer there.

Morgan

Update:

I looked at the code I used in the where_clause in civicrm_saved_search, and found that there were a few spaces missing--I fixed those and re-replaced, with no luck. Not sure if that would matter.

I then edited the smart group criteria via manage groups, which again brought up the old criteria. I changed and saved that criteria, looking via phpmyadmin saw that the where_clause in civicrm_saved_search was replaced with the original but changed data, (not the longer criteria I forced in there).

Could that data in where_clause be in another table in civi as well?

Morgan