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
9 replies
Subscribers
7 subscribers
Views
6503 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Query Entity Issue
prakharg
over 7 years ago
I have a Query Entity rule which accepts input as appId of multiple type, from my SAIL UI I am calling this rule with appIds for example {1;2;3;4}, but query entity is not returning result in same order rather it is returning CDT in Random fashion as given below:
Actual Result - [Id =3, name="Tom"];[Id=4, name="Dan"];[Id=1, name="John"];[Id=2, name="David"]
Expected Result - [Id=1, name="John"];[Id=2, name="David"];[Id =3, name="Tom"];[Id=4, name="Dan"]
appIds are passed in sequence {1;2;3;4}
This issue is creating data mismatch on UI.
Is there a way to handle this?
Thanks in Advance
OriginalPostID-251314
Discussion posts and replies are publicly visible
Parents
0
Poorna Guduri
A Score Level 1
over 7 years ago
Hi prakhar,
Could you please check the value of "sortInfo" that you have configured while passing value to the "pagingInfo" parameter of the Query Entity rule. By configuring the sort as, field - "id" and ascending - true, you can achieve the expected result.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Poorna Guduri
A Score Level 1
over 7 years ago
Hi prakhar,
Could you please check the value of "sortInfo" that you have configured while passing value to the "pagingInfo" parameter of the Query Entity rule. By configuring the sort as, field - "id" and ascending - true, you can achieve the expected result.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data