Reporting Question for Code Collaborator
I have a request to report the grandparent/parent group id of a review which by the grandchild group id has been entered in the review.
Group structure Defintion
Product Engineering (PE) (Grand Parent- L1)
Product Engineering (PE) Intergration (Parent –L2 )
Product Engineering (PE) Custom Design(Child- L3)
Product Engineering (PE) Porting (Child – L3)
Author Full Name
Product Engineering - Porting (L3)
Product Engineering (PE) (L1)
The groupgroups table allows me to find parent id of the child but there is no way for me to get the grandparent info ( in this case it is Product Engineering PE
Based on what I checked in the code collaborator interface, the information can be accessed through the Groupancestry table. I have already tried with the prefix of username i.e ccgrp1. Groupancestry , it still says table or view not found. Do you know how can I get access to this table to get the child information?
Our administrator says this field is listed in the documentation as intentionally undocumented. This means DO NOT USE this table.
So what is the alternative available for me to get access to get the mapping of the grandparent/parent/child mapping without using the
Groupancestry table? Otherwise how to get the mapping information which involve multiple level?
Your kind suggestion and support is greatly appreciated.