Mercurial > lada > lada-server
changeset 573:08084d754073
Updated sql query to fit the requirements of sorting and paging.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Thu, 19 Mar 2015 09:28:18 +0100 |
| parents | 9dd72a2860b5 |
| children | b0d674240c29 |
| files | src/main/resources/queryconf.json |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/src/main/resources/queryconf.json Thu Mar 19 09:27:49 2015 +0100 +++ b/src/main/resources/queryconf.json Thu Mar 19 09:28:18 2015 +0100 @@ -14,7 +14,7 @@ { "id": "2", "name": "MST und UMW", "description": "Abfrage der Proben gefiltert nach Messtellen ID und ID des Umweltbereichs", - "sql": "select p.id, pt.probe_id_alt, p.mst_id, p.umw_id from probe p join probe_translation pt on p.id = pt.probe_id where (p.mst_id = :mst_id OR '' = :mst_id) and (p.umw_id = :umw_id OR '' = :umw_id)", + "sql": "select p.id as id, pt.probe_id_alt as probeId, p.mst_id as mstId, p.umw_id as umwId from probe p join probe_translation pt on p.id = pt.probe_id where (p.mst_id = :mst_id OR '' = :mst_id) and (p.umw_id = :umw_id OR '' = :umw_id)", "result": [ {"dataIndex": "probeId", "header": "ProbeId", "width": 100}, {"dataIndex": "mstId", "header": "MST", "width": 100},