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
13 replies
Subscribers
8 subscribers
Views
4818 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi Everyone, We are seeing some strange behavior when we are populati
brettr
over 9 years ago
Hi Everyone,
We are seeing some strange behavior when we are populating a grid using a queryEntity inside of the with instead of a todatasubet. If we sort on a column that has all of the same data on the first page, and the same data on a couple rows on the second page, there are some rows that are never actually displayed on the grid. Our current theory is that this is occurring because there is no secondary sort field with a queryEntity, and the videos that I will link to later seem to support that. It looks like a query rule will have a secondary sort based on the "Sort query results by" configuration in the query rule itself if you change the pagingInfo.sortInfo that is passed into the query rule. Unfortunately, a queryEntity actually breaks if you pass it a pagingInfo that has an array of sortInfo, so I do not see a way to define, or force, a secondary sort field. According to documentation, it looks like sorting on multiple colum...
OriginalPostID-177486
OriginalPostID-177486
Discussion posts and replies are publicly visible
Parents
0
brettr
over 9 years ago
Tim, I should have mentioned that we are currently on 7.8, but migrating to 7.11 in the near future. We have actually tried this before, and the queryEntity will break because it does not support a pagingInfo that has an array of sortInfos.
Does a queryEntity accept multiple sortInfos in 7.11? I am looking at documentation, and it still looks like sorting on multiple fields is not supported for a queryEntity.
forum.appian.com/.../Querying_Data_From_an_RDBMS.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
brettr
over 9 years ago
Tim, I should have mentioned that we are currently on 7.8, but migrating to 7.11 in the near future. We have actually tried this before, and the queryEntity will break because it does not support a pagingInfo that has an array of sortInfos.
Does a queryEntity accept multiple sortInfos in 7.11? I am looking at documentation, and it still looks like sorting on multiple fields is not supported for a queryEntity.
forum.appian.com/.../Querying_Data_From_an_RDBMS.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data