And - notshi/dquery GitHub Wiki
Adds additional limits to the current query to narrow the results.
You can use the following operators to enhance a query.
| Operator | Description |
|---|---|
| = | Equal |
| > | Greater than |
| < | Less than |
| >= | Greater than or equal |
| <= | Less than or equal |
| != | Not equal |
| <> | Not equal |
| is null | Find missing values |
| is not null | Ignore missing values |
Examples
and xson->>'@type' = 'B1'
and xson->>'/total-budget' IS NOT NULL