{
"name" : "Query C",
"code" : "faba_view_1",
"displayType": "table",
"queryString": "select\n dayInt.generate_series as hari,\n STR_TO_DATE(CONCAT(year(STR_TO_DATE(?d1, '%Y-%m-%d')), '-', month(STR_TO_DATE(?d1, '%Y-%m-%d')), '-', dayInt.generate_series) , '%Y-%m-%d') as tanggal,\n dmn_mw,\n dmp_mw,\n bp_mw,\n cad_mw\nfrom table(generate_series(day(STR_TO_DATE(?d1, '%Y-%m-%d')), day(STR_TO_DATE(?d2, '%Y-%m-%d')))) as dayInt\nleft join (\n SELECT\n SUM(dmn_mw) as dmn_mw,\n SUM(dmp_mw) as dmp_mw,\n SUM(bp_mw) as bp_mw,\n SUM(cad_mw) cad_mw,\n date(tanggal) as tanggal\n FROM t_opsis to2\n group by date(tanggal)\n) as opsis on opsis.tanggal = STR_TO_DATE(CONCAT(year(STR_TO_DATE(?d1, '%Y-%m-%d')), '-', month(STR_TO_DATE(?d1, '%Y-%m-%d')), '-', dayInt.generate_series) , '%Y-%m-%d')\norder by dayInt.generate_seriesΒ asc;",
"queryParams": [
{
"column": "d1",
"type": "String"
},
{
"column" : "d2",
"type" : "String"
}
],
"tableIds" : [
{"tableId" : 1}
]
}
curl --location --request PUT 'http://localhost:8080/api/v1/queryLayer/1/edit' \
--header 'Content-Type: application/json' \
--data-raw '{
"name" : "Query C",
"code" : "faba_view_1",
"displayType": "table",
"queryString": "select\n dayInt.generate_series as hari,\n STR_TO_DATE(CONCAT(year(STR_TO_DATE(?d1, '\''%Y-%m-%d'\'')), '\''-'\'', month(STR_TO_DATE(?d1, '\''%Y-%m-%d'\'')), '\''-'\'', dayInt.generate_series) , '\''%Y-%m-%d'\'') as tanggal,\n dmn_mw,\n dmp_mw,\n bp_mw,\n cad_mw\nfrom table(generate_series(day(STR_TO_DATE(?d1, '\''%Y-%m-%d'\'')), day(STR_TO_DATE(?d2, '\''%Y-%m-%d'\'')))) as dayInt\nleft join (\n SELECT\n SUM(dmn_mw) as dmn_mw,\n SUM(dmp_mw) as dmp_mw,\n SUM(bp_mw) as bp_mw,\n SUM(cad_mw) cad_mw,\n date(tanggal) as tanggal\n FROM t_opsis to2\n group by date(tanggal)\n) as opsis on opsis.tanggal = STR_TO_DATE(CONCAT(year(STR_TO_DATE(?d1, '\''%Y-%m-%d'\'')), '\''-'\'', month(STR_TO_DATE(?d1, '\''%Y-%m-%d'\'')), '\''-'\'', dayInt.generate_series) , '\''%Y-%m-%d'\'')\norder by dayInt.generate_seriesΒ asc;",
"queryParams": [
{
"column": "d1",
"type": "String"
},
{
"column" : "d2",
"type" : "String"
}
],
"tableIds" : [
{"tableId" : 1}
]
}'
{}