<{{Subtitle_Weight}} class="prominent-subhead {{Show_Subtitle}}"> {{Header_Subtitle}}

Code Fix: An error occurs when you use two columns to sort Salesforce return data

~~repeating-content.html~~

Issue Description

When you use two columns to sort data returning from Salesforce, an error occurs.

Error Message

The following error occurs: “Contact ORDER BY [column name] ASC [column name] ASC LIMIT 10 OFFSET 0 ^ ERROR at Row:1:Column:928 unexpected token: [column name]”.

Resolution

The fix is available in the following K2 versions:

K2 4.7 December 2019 Cumulative Update K2 Five (5.0) December 2019 Cumulative Update K2 Five (5.1) November 2018 Cumulative Update K2 Five (5.2) May 2019 Cumulative Update K2 Five (5.3) April 2020 Cumulative Update K2 Five Platform Classic(5.4)
X X X X X Fix Pack 1
  1. Ensure you have the correct K2 version and/or Cumulative Update installed. See KB001893 to see what Fix Pack level you have installed.
  2. Download the latest Fix Pack using the links in the table above for the version you require.
  3. Install the Fix Pack to apply the fix.