-
Notifications
You must be signed in to change notification settings - Fork 0
Home
shi edited this page Apr 30, 2021
·
6 revisions
dQuery lets you query the complete IATI data, including non-standard attributes and extensions directly into the live d-portal database, in a modern browser.
+ Documentation is ongoing so please bear with us.dQuery works well if you are familiar with the IATI Standard activity elements and querying in SQL using JSONB data types in PostgreSQL. However, it shouldn't be too hard to pick up once you've done a few recipes.
Documentation 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