| Parameters |
{"datasource": "1728__table", "viz_type": "table", "url_params": {}, "granularity_sqla": null, "time_grain_sqla": "P1D", "time_range": "Last week", "groupby": ["Type of activity or programme by donors or development partners", "Total Budget", "Donor"], "metrics": [], "percent_metrics": [], "timeseries_limit_metric": null, "row_limit": 10000, "include_time": false, "order_desc": true, "all_columns": [], "order_by_cols": [], "adhoc_filters": [{"expressionType": "SIMPLE", "subject": "Type of activity or programme by donors or development partners", "operator": "IS NOT NULL", "comparator": "", "clause": "WHERE", "sqlExpression": null, "fromFormData": true, "filterOptionName": "filter_lhepsmzpm9k_hhsm8lpzeok"}, {"expressionType": "SQL", "sqlExpression": "\"Type of activity or programme by donors or development partners\" <> 'Total budget for child protection' AND \"Type of activity or programme by donors or development partners\" <> 'Total budget for development'\nAND \"Type of activity or programme by donors or development partners\" <>'% of donors budget for child protection'", "clause": "WHERE", "subject": null, "operator": null, "comparator": null, "fromFormData": true, "filterOptionName": "filter_75va3nu30qn_fxuwob1rfs"}], "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": 672, "datasource_name": "indicator2_6_disagg_data", "schema": null, "database_name": "UNICEF Cambodia", "import_time": 1642578313}
|
| Query Context |
{"datasource":{"id":96,"type":"table"},"force":false,"queries":[{"time_range":"Last week","granularity":null,"filters":[{"col":"Type of activity or programme by donors or development partners","op":"IS NOT NULL"}],"extras":{"time_grain_sqla":"P1D","having":"","where":"(\"Type of activity or programme by donors or development partners\" <> 'Total budget for child protection' AND \"Type of activity or programme by donors or development partners\" <> 'Total budget for development'\nAND \"Type of activity or programme by donors or development partners\" <>'% of donors budget for child protection')"},"applied_time_extras":{},"columns":["Type of activity or programme by donors or development partners","Total Budget","Donor"],"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":"","expressionType":"SIMPLE","filterOptionName":"filter_lhepsmzpm9k_hhsm8lpzeok","fromFormData":true,"operator":"IS NOT NULL","sqlExpression":null,"subject":"Type of activity or programme by donors or development partners"},{"clause":"WHERE","comparator":null,"expressionType":"SQL","filterOptionName":"filter_75va3nu30qn_fxuwob1rfs","fromFormData":true,"operator":null,"sqlExpression":"\"Type of activity or programme by donors or development partners\" <> 'Total budget for child protection' AND \"Type of activity or programme by donors or development partners\" <> 'Total budget for development'\nAND \"Type of activity or programme by donors or development partners\" <>'% of donors budget for child protection'","subject":null}],"align_pn":false,"all_columns":[],"color_pn":true,"database_name":"UNICEF Cambodia","datasource":"96__table","datasource_name":"indicator2_6_disagg_data","granularity_sqla":null,"groupby":["Type of activity or programme by donors or development partners","Total Budget","Donor"],"import_time":1642578313,"include_search":false,"include_time":false,"metrics":[],"order_by_cols":[],"order_desc":true,"page_length":0,"percent_metrics":[],"remote_id":672,"row_limit":10000,"schema":null,"slice_id":2230,"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"}'" dtfy=G1HP1MOO x="'
|
