Rarely, we run into an issue where parents cannot see reports. This is usually because the parent group is removed from the parent, then when the user account is created, the role of parent does not get assigned to them.INSERT INTO asp_net_user_roles (user_id, role_id) (SELECT iu.id, '65bf239d-2398-4b27-8241-d4287299754a' FROM family_trees JOIN identity_users iu ON iu.contact_id = family_trees.mother_id) ON CONFLICT DO NOTHING;
INSERT INTO asp_net_user_roles (user_id, role_id) (SELECT iu.id, '65bf239d-2398-4b27-8241-d4287299754a' FROM family_trees JOIN identity_users iu ON iu.contact_id = family_trees.father_id) ON CONFLICT DO NOTHING;