Joining child item to parent in Report Data Sources

Reports
1

I am trying to create a CSV report for a single inspection item which provides the data for the inspection and it’s parent.

I can set up the single item data source in the report builder but I have tied myself in knots about how to join up to the inspection’s parent and output attributes from both the parent asset and child inspection.

Thanks

2

Hey Chris,

I’ve put together a video to try and help you out here, the gist is try using an AQS query with join paths and then filter the AQS query with an incoming Alloy ID datasource, the video hopefully makes this clearer :slight_smile:

3

This has worked a charm. Thanks very much.

1 Like