Hi
I am wondering if there is a way to do a single query that could pull fields from multiple in Business Classes in LM admin nodes.
I have a guide that I am using to pull data from my PfiXRefValue Business class which I am already pulling records from
Level 1:
Query ALL PfiXRefValue objects WHERE
(PfiXRefValue.XRefCode.Code == "IDD78Mapped" AND
PfiXRefValue.XRefCode.Source == "DHW D78Mapped" AND
PfiXRefValue.XRefCode.Destination == "DHW D78Mapped") OR
(PfiXRefValue.XRefCode.Code == "IDD78Trust" AND
PfiXRefValue.XRefCode.Source == "DHW D78Trust" AND
PfiXRefValue.XRefCode.Destination == "DHW D78Trust")
Level 2: For Each PfiXRefValue Object Found
Query Project objects WHERE
Project.Project == PfiXRefValue.DestinationValue3
<ParentProject> = Project.IDParentProject
Currently I am pulling data from Level 1 up above and I have a few thoughts on how I am trying to achieve this one is. I am going to pull data from each Business Class individually and then create a key/value pair to find the data for Level 2 that matches a key from Level 1. However I am wondering if there is a way to do a JOIN or maybe a Subquery to get the data I am looking for by using a single query?
Appreciate the help and any ideas on the best ways to query data efficiently in IPD
