Code Fix: An error occurs when you use two columns to sort Salesforce return data
KB003550
PRODUCTK2 Five 5.4
K2 Five (5.4) Fix Pack 1
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 Platform Classic(5.4) |
|---|---|---|---|---|---|
| X | X | X | X | X | Fix Pack 1 |
- Ensure you have the correct K2 version and/or Cumulative Update installed. See KB001893 to see what Fix Pack level you have installed.
- Download the latest Fix Pack using the links in the table above for the version you require.
- Install the Fix Pack to apply the fix.
