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
7 subscribers
Views
3332 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 10 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
revat.anandsongkit
Appian Employee
over 10 years ago
@Sikhivahan - From the error message you mentioned, it seems like the error is in the way you have configured your queryrecord() expression. Could you write your expression? As for pagingInfo, you can provide more than one field to sort in.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
revat.anandsongkit
Appian Employee
over 10 years ago
@Sikhivahan - From the error message you mentioned, it seems like the error is in the way you have configured your queryrecord() expression. Could you write your expression? As for pagingInfo, you can provide more than one field to sort in.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data