Getting started with ABQL
Overview of all queries
|Return all data|
|Return some data|
|There are two root properties returned in each dataset result|
|"Schema" contains the description of each data field, including their data types|
"Results" show data itself
|Select 3 columns from all records|
|Select data from a nested object and rename the column name user friendly|
|Select the sum of the amounts and name it total|
|Working with conditions|
|Records whose property "year" equals 2015|
|A range (>2000, < / = 2010)|
Ordering data can be done on
multiple fields (in an array). Use ASC for ascending order
DESC for descending order.
Query operators ($<operator>)
Operators are used mainly in
conditions to build ranges, exclusions or inclusions.
The following operators are currently supported
A more advanced example
Get the current stock bought, subtracting everything that was sold from everything that was bought
*ABQL is based on JSON. Click here for a deeper understanding of working with JSON.
**Please note that ABQL is still in development
Click here to read the full article on Medium.