Guardian relationship to a child participating in a specific activity

Ellen Callahan

I work for a university. We currently track student and alumni data in RE. Right now, we are tracking the athletic participation of our students/alumni as Constituent Attributes on their records. We also have guardian/child relationships set-up between our students and their guardians. I would like to be able to pull a query of guardians who have a child participating in a specific sport at our university.

However, I am having a very difficult time pulling a query in which the guardian pulls as the primary constituent in the output. There doesn't appear to be a way in Raiser's Edge to query on guardian/child relationship and the child has an attribute of XYZ sport. I chatted with Blackbaud Support about this yesterday and was given two articles:

This article actually states: “It is currently not possible for the query to pull B's constituent record because the attribute is actually on A's constituent record.”

I was just wondering if anyone has a workaround, or has any advice on what to do.

Thank you!

Dariel Dixon

@Ellen Bartlett Have you considered just using the constituent query as the base and just outputting/exporting the relationship? From the way you describe it, you may just need to output the relationship information. You would query on the constituent attribute, and then use that query to drive the export, or just to output the relationship information you are looking for.

This is much easier done in the export module, as you can limit the relationship types to only the type you are looking for.

Alan French

@Ellen Bartlett the only way I can think of to do it would be to create one query to select the children who have the attribute, export their import ID or system record ID, create a second query and paste that list of IDs into Relationships > Individuals > Individual Import ID (or Individual System Record ID), then specify the relationship type.