mapp-v2

query layer - edit

Developing

Develop Env

http://localhost:8080/api/v1

PUT

/queryLayer/{id}/edit

Request

Path Params

string

required

Example:

Body Params application/json

object {0}

Example

{
  "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
    }
  ]
}

Request samples

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

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}
    ]
}'

Responses

🟢200Success

application/json

Body

object {0}

Example

{}

query layer - create

query layer - restore