Using Query Options for Executing SADL-Based Gateway Services
Document History
Availability of Features in Support Packages
Prerequisites
Related Documents
Background Information
Query Options
Query Pushdown
Step-by-Step Procedure
Access the Query Options
Restrict the Attributes Returned by the Service
Set the Default Sort Criteria for the Query Results
Switch Off Language-Specific Sorting to Improve Performance
Set the Filter Conditions
Set Range Filter Conditions
Set Filter Condition Postfix Format
Set the Maximum Number of Returned Results and the Starting Row
Set the Text Search Scope
Set the Text Search Term
Set the Threshold Similarity Value for Fuzzy Search
Sort Result by Fuzzy Search Score
Restrict the Query Results by Business Criteria
Set the Entity Parameters for Core Data Services (CDS) and External Views
Entity Parameters and Navigation
Entity Parameters and Property Mapping with Association Paths
Restrict the Query Results by User Authorizations
Specify the Aggregation Method for Analytical Measures
Set the Aggregation Count Field
Handling OData Navigation
Replacing Keys for get_entity Calls
Support for Customer Extensions
Extend OData Model with New Entity Properties
Map Entity Properties to Extension Fields
Improving OData $expand Performance
Background Information
$expand Performance
Decide Whether the Optimized SADL $expand Can Be Used
Redefining the Expand Methods of the Extension DPC
Optimized $expand with SADL and Non-SADL Entities
Appendix
Terms
Support and Issue Reporting