It looks like queryEntity does not support multiple sorts

Hi all,
We have a report that needs to be sorted on 3 different columns.
We have written the SQL and it works as expected in the db.

I'm using queryEntity to retrieve data.

However, on the UI it shows differently. I think it sorts on only one column.

After looking at the posts, it looks like queryEntity does not support multiple sorts.

Is this an expected behavior. If not, how can I achieve this?

Another query is, can we reset the sort order like how we set startIndex and batchSize.

Please suggest!!!

OriginalPostID-189105

OriginalPostID-189105

  Discussion posts and replies are publicly visible