This offer is only addressed to commercial customers including freelancers and entrepreneurs. All prices are exclusive of value added tax (VAT).
  • Share via email
  • Subscribe to blog alert

Query templates can now be run on multiple target collections defined as a parameter

Query templates can now be configured to allow multiple target collections. With this feature, you no longer have to create a separate query template for each collection. You can already create the query template just once and then run it against the allowed collections, one at a time. This improves the maintenance efficiency and is especially useful for multiple collections with the same data structure.

This feature can be activated through a toggle available in the Template Designer. Once the toggle is activated, the images/confluence/download/thumbnails/3932959795/edit-version-1-modificationdate-1725282765000-api-v2.png icon offers a dialog from which you can select the collection category and the allowed collections themselves. Minimum two collections are required, namely the default one and at least one more.

images/confluence/download/attachments/3932959795/release_notes_template_designer-version-1-modificationdate-1725282765000-api-v2.png

Once the query template is created or updated to allow multiple collections, you can choose which one of the allowed collections to query in the Template Runner. In particular, there is an additional parameter field called Target collection, which offers a drop-down with the allowed collections.

images/confluence/download/attachments/3932959795/run_query_template_multiple_target_collections-version-1-modificationdate-1725282766000-api-v2.png

The multiple allowed collections are also reflected in the widget data sources pane. If such a query template is selected as a data source of a widget, an additional field shows the Target collection parameter, with the allowed collections listed in a drop-down menu. You can select a collection from this list or select a dynamic reference from the Allowed references field on the right.

images/confluence/download/attachments/3932959795/data_sources_target_collections-version-1-modificationdate-1725282766000-api-v2.png

Find out more in: