Thursday, February 13, 2025
1 change · saas-17.2
Resolved issues and error corrections
This fix makes field service project reports use clearer database references when preparing report data. It helps avoid potential reporting errors if different joined data sources contain similarly named fields, improving reliability without changing user workflows.
Original PR description
The project report query joins multiple tables and aggregates on some fields, everything else should be in the group by clause. The group by here is using the select alias but it is better to use the full column name including the table alias, in case one of the joined tables has a column with the same name as the alias.