Skip to content

get_properties

Description

get_properties_from_instances or get_properties extracts the values for a specified property or field from all instances of specified ontologies.

The first argument is always the call of instances. The resulting values are returned as a list and can be passed to different functions, for example SUM, AVG, or COUNT.

Example

AVG(
    get_properties(
        instances(AccountHolder), risk_level
    )
)

Here, the average risk level over all account holders is calculated. Replace the operator AVG with, for example, MAX if you are looking for the highest risk level for an account holder. Replace the parameter risk_level with aum if you want to know the average value of assets under management for your account holders. The property is given as an unquoted identifier (e.g. risk_level), not as a quoted string.

You can also use the operator get_properties_from_instances in a boolean expression, if, for example, you want to trigger something when the average overall risk level raises above 3.

Add the comparison, e.g. > 3 at the end:

AVG(
    get_properties(
        instances(AccountHolder), risk_level
    )
) > 3