Change to AQS Query Results Display in Custom Reports
Overview
We are making a temporary change to the behaviour of how the results from an AQS Query Data Source are displayed in custom reports. This change will affect the display in controls when linking to multiple items to make this work consistently across all attribute types.
This change is being made to prevent report generation from failing under certain conditions described below.
Who will this affect?
This change will affect anyone using the AQS Query Data source with join attributes within the Report Builder to build custom reports.
Details
Previously, when an AQS Query resulted in multiple matched items for join attributes, this would be displayed as X Items
into the resulting table cell in the report. However, since all entries in a table column must be of the same type, this would only work for String attributes (since the entry X Items
is also a String) and would result in an error for other attribute types with the report failing to generate.
From now on, resulting cells will show a single item attribute result, similar to the current behaviour of the single join result. If multiple values are matched, only the first attribute of the first item will be displayed.
Example
Let's assume there is a project containing 4 job tasks. If the user would create a custom report using an AQS Query data source rooted on Projects and linking to Jobs via the Tasks Attribute (Project DS -> Tasks to Jobs DS -> Title). If a Table control was then added to the layout based on this data source, the display of the data in this table will change following this change.
Before Change
Previously, the table would have shown 4 Items
in the joined Tasks and Title column.
After Change
However, from now on this would display one of the job titles e.g. JOB-9
.
Note
If you would like to continue using this aggregation, this can be achieved by using a Join Data source rather than an AQS Query Data source.