I have a CDT ("x") that references CDT "y" which then references CDT "z"; both references are via a ManyToOne join column.Both y and z have a “name” field that maps to a database column in each table named “NAME”.When I try to group on the y_field.z_field.name in APN_uiPieChartFromRecordType, the Tempo Report displays: "An error occurred while retrieving the data for “<record type for x>”. The app server log reports "Unknown column 'alias2x2_.NAME' in 'field list'.I can group on x_field.name. Is it not possible to go one step farther down the chain?...
The issue is in your database structure and the data in one or more of your tables.
check out community.appian.com/.../71096
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.