Complex query using boolean operators

The complex query syntax that can be used to retrieve custom object records through the List records for a custom object API operation.

Custom object query currently supports the AND (&&), OR (||) and NOT (!) operators. Note that the operators are case-sensitive. You must use uppercase.

AND

Search for custom fields data whose status is active and activeDate is less than 2018.
```
status:active AND activeDate:<2018
```
or
```
status:active && activeDate:<2018
```

OR

Search for custom fields data whose status is active or activeDate is less than 2018.
```
status:active OR activeDate:<2018
```
or
```
status:active || activeDate:<2018
```

NOT

Search for custom fields data whose status is missing or status has a null value.
```
!_exists_:status
```
or
```
NOT _exists_:status
```
Search for custom fields data whose status is not active ( status is either missing or null).
```
 !status:active 
```
or
```
 NOT status:active 
```
Note that to search for custom fields data where status exists and its value not equal to active , use _exists_:status AND !status:active.
Search for custom fields data with field activeDate no less than 2018 (including activeDate is missing or null).
```
!activeDate:<2018 
```
or
```
NOT activeDate:<2018 
```
Note that to search for custom fields data where activeDate exists and its value is no less than 2018 , use _exists_:activeDate AND !activeDate:<2018.

Deal with the null value

The null value fields cannot be distinguished from the missing fields. Therefore, when querying by the existence of a field, it only returns the records that contain the field and the field value is not null. Query by the non-existence of one field will return the records that either miss this field or have a null value in this field.

Welcome to Zuora Product Documentation

Explore our rich library of product information

Complex query using boolean operators

AND

OR

NOT

Deal with the null value

zuora-footer