-
Notifications
You must be signed in to change notification settings - Fork 0
Order by
shi edited this page Apr 30, 2021
·
1 revision
This sorts the resulting data in ascending or descending order.
Multiple column names are separated by a comma ,.
The default order is in ascending order (low to high).
| Operator | Description |
|---|---|
| asc | Sorts in ascending order (low to high) |
| desc | Sorts in descending order (high to low) |
order by 2 descorder by 1 asc, 3 descDocumentation 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