QUERYING
Query Model
{
"selectedColumns": [
{
"columnId": 1517
},
{
"columnId": 1010
}
],
"groupByColumn": {
"columnId": 101
},
"dateStart": null,
"dateEnd": null,
"dateRangeType": 0,
"temporalAggregation": "Total",
"TextFilter": "find me",
"TextFilterColumns": {
"columnId": 1010
},
"filters": [
{
"columnId": 1517,
"values": [
"1",
"6"
],
"exclude": false,
"mode": "Equal"
}
],
"summarizeByColumn": {
"columnId": 1003
},
"sortByColumn": {
"columnId": 1003
},
"sortDescending": false,
"pageSize": 100,
"pageIndex": 0,
"getCount": true,
"excludeRecordsWithNoStats": false,
"debugMode": true
}
Query Language
Note: Quyery Language is not yet supported
Proposed QL Syntax
SELECT
Column1
,Column2
,Column3
GROUPBYColumn3
DATEFROM2016-01-01
DATETO2016-02-03
TEMPORALAGGREGATIONTotal
TEXTFILTER ‘Find me’ IN(Column5
,Column6
)
FILTERColumn7
> 5
FILTERColumn8
= (‘A’,’D’,’Y’) EXCLUDE
SUMMARIZEBYColumn2
ORDERBYColumn1
DESC
PAGESIZE 20 PAGEINDEX 0 GETCOUNT WITHSTATS DEBUGMODE