CiviCRM Community Forums (archive)

I have a smart group made up of a number of other smart groups.  These groups are based upon membership.

I'm exporting them (about 3,000 contacts) and noticed some people were missing.  I went back to the group and clicked on the letter of someone I knew was missing.  They showed up.   I queried up the group again and then pressed next until I got the to place where the person should be, missing.

Something about how the query is changed with restricting it to a letter causes the missing people to show up. 

My guess is there is something about these people, about 50 out of 3,000, that is different.

I guess my first question is has this been seen before and is there a solution?

Barring that, I have a lot of sql experience but not a lot of civi experience.  I'd like to see the raw query that is being run for pulling the entire group and how it changes when just pulling it up for a letter.  Is there an easy way to get these queries?   I can find the basis for the smart group query in civi_groups but not knowing how it assembles the final query that really doesn't help much.

So is the final sql being run cached someplaced?

Thanks

Hi,

I am experiencing the same issue on 3.4.3

Smart group shows 2 records when you do a contact search in group 'xx' but when you edit criteria you see all 24 as it should be.

Any progress?

Help! I'm having exactly this problem, and it's wreaking havoc on our ability to function as an organization.

We're divided into regional subgroups, and each subgroup has a president that has database permissions to view and contact the members in their region (generated by smart group). When I go to Manage Groups, and click to view the contacts in our New York region, I see 154 contacts. When I go to Find Contacts and select that smart group from the groups menu, I see 4 contacts. (Or sometimes 45. Or sometimes 70. I can keep clicking search over and over and get different sets of results.) If I click on the letter one of the last names, contacts show up who weren't on the original list. So, for instance, if Civi is telling me there are 4 people in the New York group (which should have 154) -- and one of them has a last name starting with P. If I click on the P, I see 7 names. If I click on "All", I might get a list of 45 or 50 people. Ack!

The problem this causes is that our regional presidents aren't able to access their members, because the permissioning is based on these groups, and they aren't functioning. So we're not able to do our annual membership renewal at the moment, or even routine correspondence.

Any thoughts or suggestions would be MOST welcome.