-
Notifications
You must be signed in to change notification settings - Fork 0
From
shi edited this page Apr 30, 2021
·
2 revisions
Tables are where the data is stored and From specifies which tables to look at to get them.
For most queries, we are only looking at the xson table.
The xson table includes the entire IATI activity elements, as well as non-standard attributes and extensions.
Multiple table names are separated by a comma ,.
For a full list of available tables in the database, please refer here.
For a full list of IATI acitivity elements, please refer here.
from xsonfrom locationDocumentation 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