Querying across Collections

Hi,

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.

Thanks

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.

Thanks
Andy

Hi,

I would like to achieve this in Data Explorer if possible, as I can set up workflows to archive “live” contacts connected to only “Archive” enquries.

I’ve tried various iterations of adding the “collectionCode”: “Archive” to points in the AQS. None of them seem to stick, and when I reload the query it’s gone.