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': [],
         }
     ],
 });

http://lada.wald.intevation.org