Support Article
Sort does not work with localization
SA-5599
Summary
On a repeat grid, when you sort on a column that is localized, the sort is done on the English values and not the localized values, for example, French.
Error Messages
Not Applicable
Steps to Reproduce
- Create a page list with one property localized.
- Insert some values in the page list and localize all values (in French, for example).
- Be certain not to have the same sort in English and the French translation:
English -> French
Value_A_en Value_B_fr
Value_B_ en Value_A_fr
Value_C_en Value_C_fr - Display the page list in a repeat grid that is localized and try to sort on the column.
Resolution
To achieve the sorting of localized values, perform the following local-change:
Prepare the page list with the localized values before loading the grid, instead of using a control to convert to a localized value on the user interface.
If you convert the page list values to localized values in the pre-activity before the grid load is performed, the clipboard then contains the localized values on which the sort can be performed.
Published March 21, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.