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.
First( ALL [Shop.Products]
where [Shop.Products.ProductCode] = "X-00014-1297"
/* searches all products in all shops and returns the first product that has a specified product code */
where RowId([Shop]) in
RowId([Shop]) of ALL [Shop.Products]
where [Shop.Products.Price] >= 20
and [Shop.Products.Price] <= 30
/* returns all shops that have a product in the price range between 20 and 30*/
Last modified 1yr ago