Automatically fetch missing parent records from child queries

[j-schreiber]

Problem Description

• When building a complex plan with different filters, it cannot always guaranteed, that a child query (e.g. Order Products) is a true subset of one of the parent records that it depends on (Product).
• Given enough complexity in the data model, the filter-options to identify parents will not 100% be aligned with the options how certain children are identified (especially if a child has multiple relevant parents, like the order product)

Requirements

• Dynamically include "missing ids" on parent objects that are already defined in the plan, but have not been fetched the first time
• Gather all missing ids from all children (e.g. unify all missing products from quote line items, contract line items, order items, etc)
• A plan-level flag to dynamically identify missing parent records and fetch them (only for parent entities that are defined in the plan) -> completeParentRecords?