Hi, I believe that with your Mapserver version you can do it by having
DATA "the_geom from (SELECT the_geom, oid, %acar% as qf FROM geotable) as foo USING UNIQUE oid USING SRID=4326" and then making the requests with an extra "acar" parameter &acar=the_column_you_want A live example http://188.64.1.61/cgi-bin/mapserv?map=/usr/map/osm-mapserver_i.map&REQUEST=GetMap&SERVICE=WMS&VERSION=1.1.1&WIDTH=1059&HEIGHT=687&LAYERS=sea,borders,POI_free_query&TRANSPARENT=TRUE&FORMAT=image%2Fpng&BBOX=-574187,6558020,1615375,7978444&SRS=EPSG:3067&STYLES=&tag=shop&value=convenience Change the request to contain &value=supermarket or &value=hardware and you will see slightly different maps. The DATA behind this is DATA "way from (select (way),osm_id,tags from osm_point where (tags @>'%tag%=>%value%')) as foo using unique osm_id using srid=3067" I have never really understood how the DATAPATTERN should be used and I have not found any examples from the documents yet. -Jukka Rahkonen- Stefanie Weykam wrote: [mapserver-users] substitute DATA parameter via URL? > Dear list members, > I would like to change the following DATA parameter via URL > DATA "the_geom from (SELECT the_geom, oid, acar as qf FROM geotable) as foo USING UNIQUE oid USING SRID=4326" > ..where acar is the variable (a table field name) that should change on request. > How would the DATAPATTERN look like? > I have tried without success: DATAPATTERN "^the_geom from (SELECT the_geom, oid, [a-z]{4} as qf FROM geotable) as foo USING UNIQUE oid USING SRID=4326" ..which throws a parsing error near (DATAPATTERN) > And I suppose the corresponding extension to the base URL would look like this? ..&map.layer[myLayer].data="the_geom from (SELECT the_geom, oid, emci as qf FROM geotable) as foo USING UNIQUE oid USING SRID=4326" ..worked fine on MapServer 4.6 (before validation war requiered) > I wonder if it was easier to retrieve the entire table and substitute the field name. But I have 6 classes with expressions like this: > EXPRESSION ([qf]> 20 AND [qf]<= 40) > ..which would make the URL-extension even longer. Anyway, I haven't figured out how to set up the corresponding validation string of the either the classitem or the logical expression or both. > I'm (still) working with MapServer v. 5.2.1 > Any examples for DATAPATTERN would be highly appreciated. > Best regards _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
