There is a Field User Property available named "DisableSort". If set to TRUE, sorting on that field is disabled, which the tooltip should then reflect accordingly.
Real time Scenario Question:
A Multi-Value Field was configured based on a destination field that is a calculated field. For this reason, the MVField cannot be sorted; however, the tooltip on the column header displays "Sortable". How can this tooltip be changed to show "Not Sortable"?
To activate that user property:
1.Open Tools
2.Navigate to the affected business component
3.Select the Field sub-object
4.Select the affected field
5.Select the Field User Prop sub-object
6.Create a new Field User Prop record:
Name = DisableSort
Value = TRUE
7.Select the business component record and compile the changes.
Alternatively, a List Column User Property of the same name is available, in case the sorting needs to be disabled on a per-applet basis.