[Closed] Show Parent's Info on Children Report

Hello everybody,
I need to show Parent's Info (Company name) on Children's (employee's) report.
I can't find parent's connections in moodle database, (as params in joomla user table) so I don't know how to pick that info.
Any advice?
Thanks,
Paolo

Connection between parents and children are in 2 places:
- Moodle roles
- Joomla users, inside params field

Hi Antonio,
thank you for helping me, I checked moodle role_assignments table in database but I can only see if X is a parent or a student, but not if X is parent of Y or Z, which is what I really need.

Moodle relationships are quite complicated. You will need to also work with the context table.

You can check the the get_parents function to have an idea.

Hi Antonio,
thank you for the advice, I actually just needed to use the get_parents function, I just changed the query to get a field from user_info_data instead of the username.
Thank you again!