CiviCRM Community Forums (archive)

I am using a custom search of my own writing:
gist.github.com/f27bf2766a3a0f7ac15c

When I run this search, it returns 9 records (correct).
When I create a smart group from that search, then search for all contacts in that smart group, it returns 8 records.
When I create a report with criteria "In Group <my smart group>" it returns 0 records.

I am not sure how to debug this issue. Any suggestions as to what might be wrong?

Cheers,
Xavier

I used the devel module to inspect the SQL that is getting run, which has helped me narrow down the problem. The relevant clause from the report query is:

    SELECT DISTINCT cgroup_civireport.contact_id
                                 FROM   civicrm_group_contact cgroup_civireport
                                 WHERE  ( cgroup_civireport.group_id IN ( 27 ) )
                                        AND cgroup_civireport.status = 'Added'
                                 UNION DISTINCT
                                 SELECT DISTINCT smartgroup_contact.contact_id
                                 FROM
       civicrm_group_contact_cache smartgroup_contact
                                 WHERE  smartgroup_contact.group_id IN ( 27 ))
       AND contact_civireport.id IN (SELECT DISTINCT tag_civireport.entity_id
                                     FROM   civicrm_entity_tag tag_civireport
                                     WHERE  entity_table = 'civicrm_contact'
                                            AND ( tag_civireport.tag_id IN ( 6 )
                                                )

I am not sure where the first SELECT comes from, as it doesn't scope by tag - perhaps this is for contacts manually added to the smart group?
The second select would be correct, except civicrm_group_contact_cache is empty! Is this supposed to be the case? Can I force a refresh of it?