Is there any way to do a "select distinct" type query to the geoserver
WFS?
Unfortunately, no. Its not in the WFS spec.
dave
----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/
It is briefly mentioned in the WFS 1.0 spec (page 60):
<ogc:Functions> <ogc:Function_Names> <ogc:Function_Name nArgs="1">MIN</ogc:Function_Name> <ogc:Function_Name nArgs="1">MAX</ogc:Function_Name> <ogc:Function_Name nArgs="1">COUNT</ogc:Function_Name> <ogc:Function_Name nArgs="1">DISTINCT</ogc:Function_Name> </ogc:Function_Names> </ogc:Functions>
If you do not need a user or application to specify the column to do the distinct on dynamically, you can always make a view in your database with the distinct query and export the view as a typename through Geoserver.
Best regards,
Bart
dblasby@anonymised.com wrote:
Is there any way to do a "select distinct" type query to the geoserver
WFS?
Unfortunately, no. Its not in the WFS spec.
dave
----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Bart van den Eijnden
OSGIS, Open Source GIS
http://www.osgis.nl
Yes, the view approach is the one we'll probably wind up using. Just curious if there was an easier/more-general way.
--saul
Bart van den Eijnden (OSGIS) wrote:
It is briefly mentioned in the WFS 1.0 spec (page 60):
<ogc:Functions> <ogc:Function_Names> <ogc:Function_Name nArgs="1">MIN</ogc:Function_Name> <ogc:Function_Name nArgs="1">MAX</ogc:Function_Name> <ogc:Function_Name nArgs="1">COUNT</ogc:Function_Name> <ogc:Function_Name nArgs="1">DISTINCT</ogc:Function_Name> </ogc:Function_Names> </ogc:Functions>
If you do not need a user or application to specify the column to do the distinct on dynamically, you can always make a view in your database with the distinct query and export the view as a typename through Geoserver.
Best regards,
Bartdblasby@anonymised.com wrote:
Is there any way to do a "select distinct" type query to the geoserver
WFS?
Unfortunately, no. Its not in the WFS spec.
dave
----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users