-
Notifications
You must be signed in to change notification settings - Fork 0
Group by
shi edited this page Apr 30, 2021
·
1 revision
- Introduction
- Getting started
- Basic Queries
-
Recipes
- Display count of certain element in org file
- Look for similar
iati-identifier
using 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
/narrative
array in multiple roots, count and grouped for a particular@ref
- Display all publishers listing (GIZ) in
participating-org/narrative
- Display all publishers with
conditions@attached
as YES - Display narratives and count, grouped by publishers with
condition@type
- Display narratives grouped by publishers with
condition@type
1 - 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