Hi Jeff, PHP = Yucky!!
I was trying to go the route of all OGC calls. The idea is to possibly expand on the options for configuring GeoMOOSE, where you would be able to configure a filtering process on a layer by layer basis. I know I can make it all work by hardcoding things. It’s just that the data is variable from the database (as it should be) and I wanted to be able to populate the distinct list upon query vs hardcoding it. The SLD path might be the best “OGC” based approach, but it end up as a two stage query this way. I’m still investigating things. Maybe I should just hardcode for the first pass and try some different approaches after the fact. Hmm, a thought, I could use a Template populated from a SQL call for the list, but it’s not OGC anymore . . . I have many potential uses for this on a layer by layer basis. Thanks for the response. bobb On Jan 10, 2017, at 10:50 AM, Jeff McKenna <jmcke...@gatewaygeomatics.com<mailto:jmcke...@gatewaygeomatics.com>> wrote: Hi Bob, I personally think you are over-complicating this: if you have full access to the PG instance, it's easiest to have your form submit a short PHP script (mapscript isn't even needed) that executes a "pg_query" returning your distinct column names. That's the easiest way. If you must stick with WMS etc, you could use a mapscript wrapper to capture something like a GetFeatureInfo request (that lists all attributes) and populate your form (see wrapper doc http://mapserver.org/ogc/mapscript.html). But if this was me I would create a short pg_query script. -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ On 2017-01-10 11:52 AM, Basques, Bob (CI-StPaul) wrote: All, Anyone have an example of how to set up a postgres call in mapfile that is used to output a GetCapabilities attribute listing? I think I said that correctly. :c) I have a layer set up as a WMS service from Postgres, I want to provide a GetCapabilities result for a “select distinct column” call to populate a layering filtering form. Is this even a WMS thing? I anticipate that this particular set of unqiue values will be added to over time in the database and thus without my knowing it. I think I could generate a SLD on the fly with the list as a call result, but that seems overly complicated for some reason. Maybe this is a DescribeLayer function?? Or do I need to move to a WFS service? Thanks bobb _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users "Not everything that can be counted counts, and not everything that counts can be counted." - Albert Einstein
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
