Question

Photo of Ken Roach

0

How can I get a list of people not in a (small) group?

2

How can I get a list of people who are not in a small group?  (This question can apply to people not in any type of group.)

Ideally we could do this if there was an option to select people not in a group.  Until this comes, is there another way to get this information?

  • Photo of Rock RMS

    2

    New data filters for data views are coming soon in McKinley 2.0 to help you create this report. In the meantim you could also add a 'Dynamic Data' block to a page with the following SQL. Be sure to change the [GroupTypeId] to be for the group type you want.

    SELECT
        [Id], [NickName], [LastName], [Email]
    FROM[Person]
    WHERE
        [Id] NOT IN(SELECT[PersonId] FROM[GroupMember] gm INNER JOIN[Group] g ON g.[Id] = gm.[GroupId] WHERE g.[GroupTypeId] = 24 AND gm.[GroupMemberStatus] = 1)

    • Ken Roach

      Ken Roach

      Thanks for this suggestion! The videos are VERY helpful. I now have a dynamic list of people not in a small group, and lists of people's birthdays! Rock rocks!

    • Photo of Ken Roach

      0

      Until the 'NOT IN A GROUP' option comes, here's one way you can get a list of people who are not in a group.  For example, "Who is not in a small group?"

      1. Create a new Group - "Not in a small group."

      2. Add a data view that selects everyone you want to consider (e.g. All Attendees and Members over 18. - everyone who could/should be in a small group.)

      2. Add all these people to the "Not in a small group" group by using the Truck (Bulk Update), Add to group.

      3. Now use a data view that selects everyone who IS in a small group (everyone who is in a group of group type 'Small Group.'

      4. Use the Truck (Bulk Update) to remove these people from the group "Not in a small group". 

      The people you have left are those who are not in a small group.

      Just be aware that this group is not dynamic because it is not based on a data view - i.e. you need to re-run this process next time to get an up-to-date list.