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

  1. Create a page list with one property localized.
  2. Insert some values in the page list and localize all values (in French, for example).
  3. 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
  4. 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.

Suggest Edit

Published March 21, 2017 - Updated October 8, 2020


100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.