Query to link Location to Reporting Establishment
Summary:
Hello, CC!
I am in a need to find a way to develop a query that can list all the Locations given for a Report Establishment(Or a Legal Employer) for a Report I am developing. Is there a way to make this? i.e from the Location A I need to get to the Reporting Establishment it is "linked" or the Legal Employer(Reporting Establishment B and/or Legal Employer C). Is it possible?
I need this to put together with my query that retrieves calendar events and link it to some locations, but I couldn't find about how can I fetch the Reporting Establishment or Legal Employer from this.