It looks like queryEntity does not support multiple sorts

queryEntity does only support single sorting at present. I'm sure the todatasubet() function does though so you can do it manually in your expression. You can update the sort programmatically by using a!save() and a!sortInfo into your local!pagingInfo definition.

Could you please suggest with a small example?

It may be helpful to review the documentation here: forum.appian.com/.../Querying_Data_From_an_RDBMS.html

For the todatasubset part look at this: forum.appian.com/.../Function_Recipes.html
For updating sort you can do the following:
a!save(local!pagingInfo.sortInfo, {a!sortInfo(field: "field1"), a!sortInfo(field:"field2")})
Give it a go then I'm sure people will help further if you run in to problems

Thanks Eliot for the info.

By the way, Tim could you please suggest an example for multiple sorts using todatasubset()

todatasubset() takes pagingInfo as an input and a!pagingInfo() can hold an array of a!sort(). Try it
forum.appian.com/.../System_Functions.html

@Tim, one quick question, as mentioned in the post the sortInfo is an array, when the user clicks on the grid column, which one of them will be taken in order to perform the sorting?

I tried resetting the sort but it doesn't reset.

Actually, we have a local!pagingInfo defined with a sort field as "ID".

The grid gets loaded and the user selects a different column to sort say "Name".

We have a button to reset the selected values.

So, under the button, we tried resetting. Along with other values, I tried resetting to the actual sort defined in the pagingInfo i.e.,

a!save(local!pagingInfo.sort,a!sortInfo(field:"ID",asc: true)

But, this doesn't reset the sort order from user selection to the one I mentioned under reset.

Any thoughts.

@Phani, are you passing the pagination information as a parameter to the query entity or applying the sort after the values are been fetched in the todatasubset?

Phani, Which solution did you implement? I have a milar requirement