CiviCRM Community Forums (archive)

I have a custom search that allows the end-user to filter on any group or groups.  This includes smart groups and regular groups.   This is working fine if the end-user directly runs the custom search.  If they filter on an existing smart group ( named "group abc"), then  save it as a new smart group (I named it 'group XYZ' ) it  works if they click "Contacts ... Manage Groups" then click the "contacts" hyperlink for that group. (they get the expected list of contacts.)

If the user clicks "Search ... Find Contacts" and filters on group XYZ, then they get an empty result set, as it seems to be ignoring the custom search filter for including contacts in "group abc".

I think the reason the ""Contacts ... Manage Groups" works correctly, is it is running my custom search which includes logic to populate the group contact cache. ( ie  CRM_Contact_BAO_GroupContactCache::load ).

Unfortunatly, this issue means that the end-user cannot use the "Schedule/Send Mass Email" action from the custom search results, as that creates a hidden smart group behind the scenes. 

I figured out and fixed my issue. It had nothing to do with allowing the user to filter on smart groups.

I had a "group by " in my sql.    This is what I added to my code to fix the issue:

if ( $onlyIDs ) {

   $groupby = "";
}else{
   $groupby = "GROUP BY contact_a.id ";

}


 $sql = "SELECT $select
      FROM  $from
      WHERE $where
      ".$groupby;