Another question about searching and membership

[groston]

I would like to search for individual contact who a) belong to a group and b) are either not members or whose membership status is chosen from a set of Membership Status (such as grace, expired, etc.). Is there a straight-forward way to accomplish this?

p.s. If I were doing this with SQL, I would probably wind up with two SELECTs that are UNIONed together; but I have no idea if the CiviCRM query building tools support this degree of flexibility.

[joanne]

If the group is a smart group then you may be able to do it via Search Builder.

Also, I seem to remember that the format you need to use with IN is (X,X,X)