Hi, I want to sort the query result. Its absolutely possible with a single

Rahul Gundu over 8 years ago

Hi,
I want to sort the query result. Its absolutely possible with a single column. But i want to sort the query result on multiple columns. It could be possible in SQL using ORDER BY keyword, may i know how to do this in APPIAN. Forum says, using Query rule it's possible. But i didn't see any option to configure this. forum.appian.com/.../Querying_Data_From_an_RDBMS.html. Could you please help me in this issue.
Thanks,
Rahul Gundu

Discussion posts and replies are publicly visible

0 Rahul Gundu over 8 years ago

To update, the issue is fixed. a!paginginfo() takes List of SortInfo. It does the job. Thanks :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 janakik over 8 years ago

Hello Rahul, Iam trying to do the multiple sort on the portal report results using queryProcessAnalytics. Looks like the results are sorting only on first column which is on top in the SortInfo array. Have you seen this behavior ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rahul Gundu over 8 years ago

Some information from forum, When a query is passed, the query's pagingInfo overrides the report's configured sorting and paging. The first valid SortInfo object in the query paging field is used to sort the results; other SortInfo objects are ignored.
forum.appian.com/.../System_Functions.html
You can find this statement in Notes under a!queryProcessAnalytics()
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 janakik over 8 years ago

Thanks Rahul.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel