Multiple Conditional Steps

In the case where you want to filter by multiple conditions, instead of writing multiple WHERE steps, you can use the AND and OR operations to chain the conditions together.

Both AND and OR take a list of expressions that evaluate to a boolean value. AND and OR will return a boolean value themselves.

AND

::WHERE(AND(<condition1>, <condition2>))

OR

::WHERE(OR(<condition1>, <condition2>))

Examples

AND

QUERY GetUsers(name: String) =>
    users <- N<User>::WHERE(
                AND(
                    _::{age}::GT(18),
                    _::{age}::LT(30)
                )
            )
    RETURN users

OR

QUERY GetUsers(name: String) =>
    users <- N<User>::WHERE(
                OR(
                    _::{age}::GT(18),
                    _::{age}::LT(30)
                )
            )
    RETURN users

AND and OR

QUERY GetUsers(name: String) =>
    users <- N<User>::WHERE(
                AND(
                    _::{age}::GT(18),
                    OR(
                        _::{name}::EQ("John"),
                        _::{name}::EQ("Jane")
                    )
                )
            )
    RETURN users