The ALL
keyword is used to access all entities in nested entities, bypassing the parent-rows.
For example, you have the entities [Shop]
and [Shop.Products]
where [Shop.Products]
is the nested entity.
When you use Count([Shop.Products])
, you’ll get number of products from the current shop only.
If instead you want to count all products from all shops, you can write:
Count(ALL [Shop.Products])
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
Returns all entities of a given nested entity without limiting by active parent row.