-
Notifications
You must be signed in to change notification settings - Fork 0
And
shi edited this page Apr 30, 2021
·
2 revisions
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 |
and xson->>'@type' = 'B1'and xson->>'/total-budget' IS NOT NULLDocumentation is ongoing - please bear with us. Any feedback is appreciated.
- Introduction
- Getting started
- Basic Queries
-
Recipes
- Display count of certain element in org file
- Look for similar
iati-identifierusing a wildcard% - Filtering on custom namespace elements
- Display iati-organisation id with curated elements within
total-budget - Group by publishers that use a particular
@ref - Display first
/narrativearray in multiple roots, count and grouped for a particular@ref - Display all publishers listing (GIZ) in
participating-org/narrative - Display all publishers with
conditions@attachedas YES - Display narratives and count, grouped by publishers with
condition@type - Display narratives grouped by publishers with
condition@type1 - Display an element attribute, grouped in descending order
- Display full activity data within an element for multiple identifiers
- Display identifiers sorted by the second column (narrative) in descending order
- Display number of items with full activity data for an element and vocab
- Subquery to get full activity data
- Display full activity data with attribute of certain value
- Display unique activity identifiers with attribute of certain value
- Get a table of most used values sorted by count
- Display all activities for a country_code within COVID-19