Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+1
person also asked this
people also asked this
Replies
6 replies
Answers
3 answers
Subscribers
12 subscribers
Views
8294 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
What are the limitations of Query Entity?
rakshandad
over 6 years ago
What are the limitations of Query Entity?
Discussion posts and replies are publicly visible
Parents
0
sahilb346
over 6 years ago
Hello,
You can find out the details for query Entity in the documentation. One thing I want to tell about query entity is by default the query entity sort the result on the basis of the first selected column.
For example:-
If you are not defining any sort field with query Entity:-
a!queryEntity(
entity: Entity Name
query: {
a!query(
selection:{
a!querySelection(
columns: {
a!queryColumn(
field: "columnA"
),
a!queryColumn(
field: "columnB"
)
}
)
},
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: -1
)
)
}
)
The above query will give the result and the sorting of the result will be on the column :- columnA .
This may be not the exact answer you are looking for, but may be this will help you.
Thanks
Sahil Batra
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel
Reply
0
sahilb346
over 6 years ago
Hello,
You can find out the details for query Entity in the documentation. One thing I want to tell about query entity is by default the query entity sort the result on the basis of the first selected column.
For example:-
If you are not defining any sort field with query Entity:-
a!queryEntity(
entity: Entity Name
query: {
a!query(
selection:{
a!querySelection(
columns: {
a!queryColumn(
field: "columnA"
),
a!queryColumn(
field: "columnB"
)
}
)
},
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: -1
)
)
}
)
The above query will give the result and the sorting of the result will be on the column :- columnA .
This may be not the exact answer you are looking for, but may be this will help you.
Thanks
Sahil Batra
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel
Children
No Data