Mercurial > lada > lada-client
changeset 244:7097182150d9
Added filter attribute and added comments.
author | Torsten Irländer <torsten.irlaender@intevation.de> |
---|---|
date | Tue, 23 Jul 2013 14:14:45 +0200 |
parents | 331c77afdbcb |
children | 9a2c04b19874 |
files | app/model/Query.js app/store/Queries.js |
diffstat | 2 files changed, 9 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/app/model/Query.js Tue Jul 23 11:45:10 2013 +0200 +++ b/app/model/Query.js Tue Jul 23 14:14:45 2013 +0200 @@ -6,6 +6,7 @@ {name: "description"}, {name: "sql"}, {name: "fields"}, + {name: "filters"}, ], proxy: { type: 'memory',
--- a/app/store/Queries.js Tue Jul 23 11:45:10 2013 +0200 +++ b/app/store/Queries.js Tue Jul 23 14:14:45 2013 +0200 @@ -24,14 +24,20 @@ 'name': 'MST, UWB', 'description': 'Beschreibung der MST, UWB Abfrage', 'sql': 'select * from xxx', - 'fields': ['datenbasisId', 'mplId', 'umwId', 'messmethode', 'hauptprobenNr', 'nebenprobenNr', 'bezeichnung', 'kreis', 'probeId', 'mstId'] + /* List of fields which should be displayed in the proben list. + * The field names must match the fieldnames in returned JSON object. */ + 'fields': ['datenbasisId', 'mplId', 'umwId', 'messmethode', 'hauptprobenNr', 'nebenprobenNr', 'bezeichnung', 'kreis', 'probeId', 'mstId'], + /* List of filters. The filters must match the fields in the + * "WHERE" part of the defined SQL query. */ + 'filters': ['mstId', 'umwId'], }, { 'id': '2', 'name': 'Rbegin', 'description': 'Beschreibung der Rbegin Abfrage', 'sql': 'select * from xxx', - 'fields': ['mplId', 'datenbasisId', 'umwId', 'messmethode', 'hauptprobenNr', 'nebenprobenNr', 'bezeichnung', 'kreis', 'probeId', 'mstId'] + 'fields': ['mplId', 'datenbasisId', 'umwId', 'messmethode', 'hauptprobenNr', 'nebenprobenNr', 'bezeichnung', 'kreis', 'probeId', 'mstId'], + 'filters': [], } ], });