Querying across Collections


I have a set of Assets in the “Live” collection, with a large number of inspections in both the “Live” and “Archive” collections. Is there a way to query only the live Assets, but the live and archive inspections. i.e. I don’t want end dated assets showing on the reports.


Hi Colin,

This should be possible via custom reports. You can have a data source for the Assets with only the live collection selected, and a seperate data source for the inspections across both Live and Archive collections. You can then use a join data sorce to connect both of these together via the item id of the inspection, and the “inspections” link attribute on the asset design.
You should also be able to achieve this in Data Explorer but it would be simplier to do this in a custom report.

Let us know how you get on with this.