Error when sorting a column for an object in the datamanager
Example test.cfc preside object with 2 relationships to crm_organisation object. The organisation label field is a formula field which looks something like:
The test.cfc looks like:
In the datamanager for the test object, if you try to sort by either organisation or other_organisation. it will throw an error:
Further checking, the line in DataManagerService's getRecordsForGridListing:
returns "IfNull( crm_organisation.branch_name, crm_organisation.legal_name ) asc" which is ambiguous as there is organisation and other organisation field. Adding relatedVia to the 2 fields does not help the situation.
Example error log: