-
Notifications
You must be signed in to change notification settings - Fork 0
Getting started
The current interface is sparse and consists of two panels; the editor on the left and the console on the right.
There are four buttons above these panels which perform various things.
Examples
Some example recipes.
Run Query
View results in the browser.
If queries are complex, this can slow down the browser.
Browse Activities
View results in d-portal.
Download XSON
Download data in various formats without viewing results in the browser.
You can drag the partition to increase or decrease the space of either panel.
Downloads of data is available as csv, json, xml and html.
The html option will only work at the top level of an activity or an organisation file; ie. when select *, the root needs to be at either /iati-activities/iati-activity or /iati-organisations/iati-organisation.
The html option is a Print-friendly version of SAVi (Simple Activity Viewer).
Replace /# in the url with ?form=csv&sql= to get the query link in different formats.
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