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
GROUPBY Column3
DATEFROM 2016-01-01
DATETO 2016-02-03
TEMPORALAGGREGATION Total
TEXTFILTER ‘Find me’ IN(Column5,Column6)
FILTER Column7 > 5
FILTER Column8 = (‘A’,’D’,’Y’) EXCLUDE
SUMMARIZEBY Column2
ORDERBY Column1 DESC
PAGESIZE 20 PAGEINDEX 0 GETCOUNT WITHSTATS DEBUGMODE