$select
Contents
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.