and_query {ODataQuery}

Create a combined filter

Description

Create a combined filter

Usage

and_query(...)

or_query(...)

not_query(...)

Arguments

...

Raw odata queries or query options.

Details

This function can be used with raw values or query options

1. Raw odata queries Raw OData can be passed as string. It's the responsibility of the caller that the argument is valid syntax and values are escaped.

2. Query options Query options can be passed as named parameters.

Query options should be of the following form: property.operator = value

• Property should be a property of the entity or individual.

• Operation can have any of the following values:

  • eq Whether property is equal to value.

  • ne Whether property is not equal to value.

  • gt Whether property is greater than value.

  • ge Whether property is greater than or equal to value.

  • lt Whether property is lower than value.

  • le Whether property is lower than or equal to value.

  • has Whether property has value as enumeration property.

  • startswith Whether property starts with value.

  • endswith Whether property ends with value.

  • contains Whether property contains value.

• Value should be a string, double or boolean and will be escaped automatically.

See Also

https://docs.oasis-open.org/odata/odata/v4.0/errata03/os/complete/part2-url-conventions/

Examples

and_query("Column eq OtherColumn",
          FirstName.startswith = 'A',
          LastName.eq = 'Scott')

or_query("ExpireDate eq null",
         ExpireDate.lt = "2020-07-07")

not_query(or_query(Age.lt = 21, Age.gt = 65))