| Parameters |
{"datasource": "3547__table", "viz_type": "table", "slice_id": 18268, "url_params": {}, "granularity_sqla": null, "time_grain_sqla": "P1D", "time_range": "Last week", "groupby": [], "metrics": [], "percent_metrics": [], "timeseries_limit_metric": null, "row_limit": 10000, "include_time": false, "order_desc": true, "all_columns": ["cal_number", "indicator_khmer"], "order_by_cols": [], "adhoc_filters": [{"expressionType": "SIMPLE", "subject": "indicator_no", "operator": "!=", "comparator": "0", "clause": "WHERE", "sqlExpression": null, "fromFormData": true, "filterOptionName": "filter_x1twdum9oih_dqybxc7he5"}], "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "page_length": 0, "include_search": false, "table_filter": false, "align_pn": false, "color_pn": true, "remote_id": 18268, "datasource_name": "summary_domain3_khmer", "schema": "khmer", "database_name": "UNICEF Cambodia", "import_time": 1637585024}
|
| Query Context |
{"datasource":{"id":160,"type":"table"},"force":false,"queries":[{"time_range":"Last week","granularity":null,"filters":[{"col":"indicator_no","op":"!=","val":"0"}],"extras":{"time_grain_sqla":"P1D","having":"","where":""},"applied_time_extras":{},"columns":["cal_number","indicator_khmer"],"metrics":[],"orderby":[],"annotation_layers":[],"row_limit":10000,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{},"post_processing":[]}],"form_data":{"adhoc_filters":[{"clause":"WHERE","comparator":"0","expressionType":"SIMPLE","filterOptionName":"filter_x1twdum9oih_dqybxc7he5","fromFormData":true,"operator":"!=","sqlExpression":null,"subject":"indicator_no"}],"align_pn":false,"all_columns":["cal_number","indicator_khmer"],"color_pn":true,"database_name":"UNICEF Cambodia","datasource":"160__table","datasource_name":"summary_domain3_khmer","granularity_sqla":null,"groupby":[],"import_time":1637585024,"include_search":false,"include_time":false,"metrics":[],"order_by_cols":[],"order_desc":true,"page_length":0,"percent_metrics":[],"remote_id":18268,"row_limit":10000,"schema":"khmer","slice_id":1079,"table_filter":false,"table_timestamp_format":"%Y-%m-%d %H:%M:%S","time_grain_sqla":"P1D","time_range":"Last week","timeseries_limit_metric":null,"url_params":{},"viz_type":"table","force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}
|
