OData Parameters for Queries with the Property By Easy Query or By OData
| Parameter | Description |
|---|---|
|
$metadata |
|
|
&sap-ds-debug=true |
Debug mode provides information at runtime. |
|
../QuerynameResults |
Result set without variables |
|
../QuerynameResults?$inlinecount=allpages |
Result set with number of lines |
|
../QuerynameResults?$skip=10 |
Result set without the first 10 lines, but with all subsequent ones |
| ../QuerynameResults?$top=3 |
Result set with the three first lines (top3) |
|
../QuerynameResults?$skip=5&$top=3 |
Result set with the three first lines beginning with line 6 |
|
../QuerynameResults?$skip=0&$top=3&$orderby=char1 desc |
Result set with the three first lines in accordance with sorting by characteristic 1 |
|
../QuerynameResults?$orderby=char1 desc (asc/desc) |
Result set sorted by characteristic 1 |
|
../Queryname(var1=value,var2=value,...)/Results |
Result set with variables (single value selection) |
|
../Queryname(var1=datetime'2013-08-05T00:00:00')/Results |
Result set with date variables (single value selection) |
| ../Queryname(var1_INTERVAL_START=value,var1_INTERVAL_END=value)/Results |
Result set with variables (range selection) |
|
../QuerynameResults?$select=char1,char2,keyf4... |
Output size of the result set reduced by field selection (can be rolled up) |
|
../QuerynameResults?$filter=char1eq'value' |
Output size of the result set reduced by filters |
|
../Queryname(..)/Results?$select=...&$filter=...&sap-ds-debug=true |
Result set with variables, filters, field selection and debug mode |
|
../Queryname?$select=var1 |
Input help (F4) for variable 1 (var1), key only |
|
../Queryname?$select=var1,var1Text |
Input help (F4) for variable 1 (var1), key and text |
|
../Queryname?$select=var1&$filter=var2eq'value' |
Input help (F4) for variable 1 (var1), with restriction to variable 2 (var2) |