The value of the $select query option is:
•a comma separated list of property paths
•qualified action names
•qualified function names
•the star operator (*)
•the star operator prefixed with the name of the entity container in order to specify all operations within the container.
The following fields are allowed:
•String or numeric information like "Hello", 1.3442, true/false
•Columns from current Entity or from Entities, which you can link to the current Entity
You can rename the result field with the as command.
For example, the following request returns only the item code and item name of the matching items:
Item?$select=ItemCode,ItemName |
Requesting all properties, using star(*):
Item?$select=* |
A star request should not introduce actions or functions, that are not otherwise requested.
Item and UoM present a complete entity and returns all fields from this entity:
Item?$select=Item,UoM
Returns a field from the related sub-object:
Item?$select=UoM/RoundDec
Rename column field with the as command.
Example: Return the ItemName column calling it the "Description" column.
Item?$select ItemName as Description
Placeholder, function calls and strings
Item?$select=" " as EmptyField,CurrentDate as Today,concat(ItemName," ",ItemCode," ",OnHand) as info
If you do not define an as description and it is not a column of an entity, then the system return the result with field name: "computexxxx"
Attention:
It is not mandatory in Beas Service Layer to define sub-objects in the $expand query option. For more information, see $expand.
Max. return size is 16 MByte (8 Million Chars). The system will cut the information without additional message.