Skip to Content
1
Former Member
Dec 26, 2022 at 04:57 PM

Odata draft Sort query is Case Sensitive (CAP Node.js)

435 Views Last edit Dec 28, 2022 at 12:28 PM 7 rev

Hi colleagues. I faced the issue of the Sort feature - it is case sensitive (e.g. for Ascending sort - first goes Upper case Names, only then lower case).

My tech stack: Fiori Elements and CAP with Node.js with ODatav4.

image.png

A table inside List Report presents entities properties and with enabled Draft mode. And the problem is that on deployed systems the sort feature is case sensitive (first go Upper case Names, only then Lower case).

But in the local environment sorting works nice, as requested (the screenshots are below).

For local setup we are using SQLite vs Hana in deployment envs.

Maybe somebody knows what is wrong and how to fix it.

Thanks.

Correct sorting, ASC (like we want - names with small capital letters are among names with uppercased names):

correct-sorting.png


Wrong sorting
, ASC (actual behavior - names with small capital letters are below the names with uppercased names):

incorrect-sorting.png

Attachments

image.png (6.7 kB)