Best way to report on faculty children

Ashley Foltiny

Hi all,

How do you report on faculty children? Right now I have an advanced list in core that pulls parent/child relationship > User base > user detail. And I repeat that 6 times for each potential child. Is there an easier/better way to do this? Under object filters, I also have to pull Parent/Child Relationship Ordinal = 1, 2, 2, etc.

John Ronan

@Ashley Foltiny,

Not exactly sure what you're after here and I can't quite make out your screenshots.

But to get all students who have faculty parents, I'd use an advanced list as follows:

• in the Select objects, I'd have:
  • user base - the child
    • user role
    • parent/child relationship
      • user base[1] - this is the parent object
        • Employee - employee employment [the parent's employment]
• in the Filter tab, I'd have something like:
  • employee employment.end date is null
  • user role is “student”