Problem/Limitation Description

Sorting on reference attributes in a query will not work if query searches business object group. For example, sorting in the following query will not work if Account is business object group:

FIND Account ORDER BY Account.Owner.Name 

Work Around

Define a shortcut attribute and sort by it, for example:

FIND Account ORDER BY Account.OwnerName 

Where OwnerName is the shortcut to Account.Owner.Name

  • Last modified: 2023/05/10 01:23