What are the limitations of Query Entity?

Question

Mangesh Vidhale · Answer

This may helps you 
 
 docs.appian.com/.../Post-Install_Configurations.html 
 
 docs.appian.com/.../Configuring_Relational_Databases.html

Ravichandran Thiruganasambandham (Ravi Sam) · Answer

Along with Mangesh inputs, do consider database performance best pracitices also, 
 community.appian.com/.../database-performance-best-practices

sahilb346 · Answer

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