All

This Flow Script tutorial explains how to use the All function with syntax and examples.

Description‌

Obsolete function.

The All function returns a boolean value indicating whether the predicate expression holds true for all rows in the table.

The Any function can be used to achieve the same result as All.

Syntax

‌The syntax for the All function is:

All(table, predicate)

‌Parameters

table - the table which is to be checked.

predicate - the value to be checked in the table if true or not.

Returns

‌The All function returns True or False.

Example‌

Let's look at some All function examples and explore how to use the All function.‌

Example table: orderQuantity

All([a: 1] & [a: 2], {a > 1})
Result: False

All(orderQuantity,{Quantity > 2})
Result: True

All(orderQuantity,{Quantity > 10})
Result: False

The Any function to do the same check:
not Any(orderQuantity where Quantity <= 10)
Result: False