When filtering for a parent company, I want to return records associated directly with the parent company and the child companies. I think a field that is akin to coalesce(parent_company_id, company_id) could work, but I don’t see a way to create this in Gainsight Company object.

For example, I have a parent company A with child companies B and C. If I am filtering for associated GS Opportunity records and filter for A, I’d want to return records for A, B and C.