Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
8 subscribers
Views
3686 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi all, I am trying to set the 'sort' parameter 'pagingInfo' of
sikhivahans
over 11 years ago
Hi all, I am trying to set the 'sort' parameter 'pagingInfo' of query record with multiple fields. But I am getting the following error when trying to do so : "Expression evaluation error at function 'queryrecord': Error evaluating function 'queryrecord' : Cannot sort by multiple fields."
Here goes my configuration:
pagingInfo: 'type!PagingInfo'(
startIndex:1,
batchSize:-1,
sort:{{field:"firstName", ascending:true()},{field:"lastName", ascending:true()}}
)
Did I do any mistake in the configuration? Or do pagingInfo of queryrecord() doesn't accept sortinfo array? Bu the same 'sort' configuration worked fine when passed to a query rule. I am just curious to know why the same 'sort' configuration which worked fine when passed to query rule isn't working when passed to 'pagingInfo' in 'query' parameter of queryrecord().
Thanks in advance....
OriginalPostID-78481
OriginalPostID-78481
Discussion posts and replies are publicly visible
Parents
0
sikhivahans
over 11 years ago
@revat.anandsongkit if I sort on one field,its working fine But issue is with multiple sort fields. My doubt here is whether queryrecord can accept multiple sort fields or not, because ultimately it is the paging info which will be passed to queryrecord and sort in paginginfo is an array.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 11 years ago
@revat.anandsongkit if I sort on one field,its working fine But issue is with multiple sort fields. My doubt here is whether queryrecord can accept multiple sort fields or not, because ultimately it is the paging info which will be passed to queryrecord and sort in paginginfo is an array.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data