Filtering

Either-or

Group terms in or=(...) to keep rows matching any of them.

or=(status.eq.done,owner.name.eq.Linus)or=(a.eq.1,and(b.eq.2,c.eq.3))

Each term is column.operator.value, with the same operators and relation paths as a filter. Inside an or, and(...) groups terms that must all hold, one level deep.

An or combines with the request's other filters: they must all hold, and so must the or.

Examples

Done, or owned by Linus.

/todos?select=name&or=(status.eq.done,owner.name.eq.Linus)

Asking the database...

Done, or both pinned and longer than three hours.

/todos?select=name&or=(status.eq.done,and(pinned.is.true,estimate.gt.3))

Asking the database...

Either-or

Group terms in or=(...) to keep rows matching any of them.

or=(status.eq.done,owner.name.eq.Linus)or=(a.eq.1,and(b.eq.2,c.eq.3))

Each term is column.operator.value, with the same operators and relation paths as a filter. Inside an or, and(...) groups terms that must all hold, one level deep.

An or combines with the request's other filters: they must all hold, and so must the or.

Examples

Done, or owned by Linus.

/todos?select=name&or=(status.eq.done,owner.name.eq.Linus)

Asking the database...

Done, or both pinned and longer than three hours.

/todos?select=name&or=(status.eq.done,and(pinned.is.true,estimate.gt.3))

Asking the database...