Which of the following approaches should be used as part of solution?

Multiple case types within the Booking application’s case hierarchy can produce FSG-Data-Pricing records, BookEvent and VehicleParking, for example. To generate a customer’s invoice, the Booking team needs to collect every Pricing record related to a given BookEvent case.

Which of the following approaches should be used as part of solution?
A . Define an FSG-Booking-Work-BookEvent Report Definition that defines a JOIN to FSG-Booking-Work-BookEvent aliased as “CHILD”. The JOIN compares pyOrigOrg values. The Query tab’s filter condition compares CHILD.pzInsKey to the pxCoveredInsKeys ValueList which generates an ((A = B) or (A = C) or…) clause.
B . Define an SQL Function named isInCaseHierachy() that takes two parameters, one being the passed-in pyID of the parent case, the other being the Reference property within the FSG-Data-Pricing record Pricing record.
C . Define an FSG-Booking-Work subreport that uses Do Not JOIN rows. The main FSG-Booking-Work-BookEvent Report Definition declares a ParentKey parameter which is passed to the subreport. The subreport filters on pxCoveredInsKey = param.ParentKey. Main report filters on pzInsKey = SUBRPT.pxCoveredInsKey which generates an IN clause. The main report OR’s that filter with pzInsKey = param.ParentKey
D . Define an FSG-Booking-Data-CaseHierarchy class. Within each row of that class, both the pyID of the BookEvent case and the pyID of a BookEvent child case are persisted. That generated table is joined to FSG-Data-Pricing’s Reference property.

View Answer

Answer: C