Poniższa konfiguracja opiera się na źródle danych na podstawie zapytań do bazy, której implementacja znajduje się we wtyczce com.suncode.plugin.jdbc-datasources. Bez tej wtyczki poniższa konfiguracja nie będzie poprawnie działać.
...
| Code Block | ||
|---|---|---|
| ||
[
{
"id": "zrodlo3",
"name": "Kategorie",
"description": "sefsef",
"type": "jdbcQueryDatasource",
"categories": null,
"parameters": {
"connection": {
"type": "string",
"value": "system"
},
"query": {
"type": "string",
"value": "select * from pm_systemparametercategory order by {orderProperty} {orderDirection} LIMIT {limit} OFFSET {start}"
},
"countQuery": {
"type": "string",
"value": "select count(*) from pm_systemparametercategory"
},
"queryParametersId": [],
"queryParametersName": [],
"queryParametersType": [],
"queryResultColumnsId": [
{
"type": "string",
"value": "id"
},
{
"type": "string",
"value": "categorykey"
}
],
"queryResultColumnsName": [
{
"type": "string",
"value": "id"
},
{
"type": "string",
"value": "Klucz kategorii"
}
]
},
"operationsoperation": null"READ"
},
{
"id": "zrodlo2",
"name": "Role",
"description": "sefsef",
"type": "jdbcQueryDatasource",
"categories": null,
"parameters": {
"connection": {
"type": "string",
"value": "system"
},
"query": {
"type": "string",
"value": "select * from pm_roles order by {orderProperty} {orderDirection} LIMIT {limit} OFFSET {start}"
},
"countQuery": {
"type": "string",
"value": "select count(*) from pm_roles"
},
"queryParametersId": [],
"queryParametersName": [],
"queryParametersType": [],
"queryResultColumnsId": [
{
"type": "string",
"value": "id"
}
],
"queryResultColumnsName": [
{
"type": "string",
"value": "id"
}
]
},
"operationsoperation": null"READ"
},
{
"id": "zrodlo1",
"name": "Parametry systemowe",
"description": "sefsef",
"type": "jdbcQueryDatasource",
"categories": null,
"parameters": {
"connection": {
"type": "string",
"value": "system"
},
"query": {
"type": "string",
"value": "select * from pm_systemparameter \nwhere categoryid = {categoryid}\norder by {orderProperty} {orderDirection} LIMIT {limit} OFFSET {start}"
},
"countQuery": {
"type": "string",
"value": "select count(*) from pm_systemparameter\nwhere categoryid = {categoryid}"
},
"queryParametersId": [
{
"type": "string",
"value": "categoryid"
}
],
"queryParametersName": [
{
"type": "string",
"value": "Id kategorii"
}
],
"queryParametersType": [
{
"type": "string",
"value": "integer"
}
],
"queryResultColumnsId": [
{
"type": "string",
"value": "id"
},
{
"type": "string",
"value": "parameterkey"
},
{
"type": "string",
"value": "categoryid"
},
{
"type": "string",
"value": "valuestring"
},
{
"type": "string",
"value": "valuelong"
}
],
"queryResultColumnsName": [
{
"type": "string",
"value": "Id"
},
{
"type": "string",
"value": "Klucz parametru"
},
{
"type": "string",
"value": "Klucz kategorii"
},
{
"type": "string",
"value": "Wartość tekstowa"
},
{
"type": "string",
"value": "Wartość liczbowa"
}
]
},
"operationsoperation": null"READ"
},
{
"id": "categoriesListSource",
"name": "Kategorie - typ 'list'",
"description": "asdf",
"type": "jdbcQueryDatasource",
"categories": null,
"parameters": {
"connection": {
"type": "string",
"value": "system"
},
"query": {
"type": "string",
"value": "select categorykey as text, id as value\nfrom pm_systemparametercategory\nwhere lower(pm_systemparametercategory.categorykey) like concat('%', lower({query}), '%')"
},
"countQuery": {
"type": "string",
"value": "select count(*)\nfrom pm_systemparametercategory \nwhere lower(pm_systemparametercategory.categorykey) like concat('%', lower({query}), '%')"
},
"queryParametersId": [
{
"type": "string",
"value": "query"
}
],
"queryParametersName": [
{
"type": "string",
"value": "query"
}
],
"queryParametersType": [
{
"type": "string",
"value": "string"
}
],
"queryResultColumnsId": [
{
"type": "string",
"value": "value"
},
{
"type": "string",
"value": "text"
}
],
"queryResultColumnsName": [
{
"type": "string",
"value": "value"
},
{
"type": "string",
"value": "text"
}
]
},
"operationsoperation": null"READ"
},
{
"id": "widokZadanDataSource",
"name": "Tabela zadań",
"description": "sfsef",
"type": "jdbcQueryDatasource",
"categories": null,
"parameters": {
"connection": {
"type": "string",
"value": "system"
},
"query": {
"type": "string",
"value": "SELECT * FROM activities \nWHERE state = 1000001\norder by {orderProperty} {orderDirection} LIMIT {limit} OFFSET {start}"
},
"countQuery": {
"type": "string",
"value": "SELECT COUNT(*) FROM activities\nWHERE state = 1000001"
},
"queryParametersId": [],
"queryParametersName": [],
"queryParametersType": [],
"queryResultColumnsId": [
{
"type": "string",
"value": "id"
}
],
"queryResultColumnsName": [
{
"type": "string",
"value": "id"
}
]
},
"operationsoperation": null"READ"
},
{
"id": "widokZadanPodsumowanie",
"name": "Tabela zadań - podsumowanie",
"description": "sfsef",
"type": "jdbcQueryDatasource",
"categories": null,
"parameters": {
"connection": {
"type": "string",
"value": "system"
},
"query": {
"type": "string",
"value": "SELECT sum(characterscount) as summary FROM (\n\tSELECT char_length(id) AS characterscount\n\tFROM activities \n\tWHERE state = 1000001\n ORDER BY {orderProperty} {orderDirection} LIMIT {limit} OFFSET {start}\n) _"
},
"countQuery": {
"type": "string",
"value": "SELECT 1 AS count"
},
"queryParametersId": [],
"queryParametersName": [],
"queryParametersType": [],
"queryResultColumnsId": [
{
"type": "string",
"value": "summary"
}
],
"queryResultColumnsName": [
{
"type": "string",
"value": "Liczba znaków w id"
}
]
},
"operationsoperation": null"READ"
}
] |
Import konfiguracji wtyczki DataViewer
...