SortMapping

SortMapping allows a developer to sort by a column other than the retrieval field column. For example, the following will cause the Title field to sort by the column FULL_TITLE instead of by the displayFieldSqlName (TITLE):

<CustomRetrievalField>
<FieldRef levelType="ZBKS.Book" category="PDF">
<FieldName>Title</FieldName>
</FieldRef>
<Type>MODEL_LINK</Type>
<ModelLinkMapping surrogateIdSqlName="SYS_BOOK_ID" displayFieldSqlName="TITLE"/>
<SortMapping sqlName="FULL_TITLE" type="STRING"/>
</CustomRetrievalField>


Address and Composite retrieval fields are not sortable by default on UI. But you can provide SortMapping for these fields to make them sortable.