Error when sorting a column for an object in the datamanager

Description

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:

Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Unassigned

Reporter

Kok Ann Ng