Querying across Collections

Reports
1

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

2

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

3

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.

4

Hi,

I have another instance where I have an (Incorrectly) Archived job, with a live status. The basic logic I am trying to run is “All Archived jobs that don’t have a completion date, and have a live status of issued”.