CiviCRM Community Forums (archive)

(Sorry if this has been asked before ... I did a forum search for some keywords and didn't see a thread about it ...)

Is there some way to do the following search without writing a custom query:

* Show me all contacts at the opposite end of a given relationship to all contacts with given membership(s) in given state(s)

Here's what I've got:

I'm using CiviCRM to manage a children's choir. I've got both my choristers and their parents loaded as individual contacts related by a Child/Parent Of relationship. Choristers have to renew their membership in the choir each year, so I have their participation recorded as a membership. This works well, since if a chorister terminates membership in the middle of a season, I just mark their membership as Canceled. We have four choir levels (by age, roughly), so I created four separate memberships - one per choir.

My problem is this: I would like to create a mailing list group of all choristers that are New or Current members of a particular choir - I know I can do by using an advanced query to create a smart group.

But I also would like to create a mailing list group of all contacts with a Parent Of relationship to a contact who is a New or Current member of a particular choir. I've written a custom query to do this which works just fine, but every time I upgrade I forget to copy over the custom query classes and end up having to retrieve them from my backup.

Question: Is there some way to create a smart group for the parents of my members without writing a custom query? I'm wondering if this is, in fact, possible but that I've overlooked how to do it.

Thanks for any help you can provide.

-eP