It looks like queryEntity does not support multiple sorts

phanibabuk over 8 years ago

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!!!

Discussion posts and replies are publicly visible

Parents

0 phanibabuk over 8 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 phanibabuk over 8 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data