Thanks for all these links. I have almost managed to get the syntax I
am looking for. I am still stuck on setting a field to NULL. This _expression_ parses <OCQL>if_then_else(equalTo(CAT_DESC, 'No Name'), 'NULL', CAT_DESC)</OCQL> This does not <OCQL>if_then_else(equalTo(CAT_DESC, 'No Name'), NULL, CAT_DESC)</OCQL> Am I approaching this wrong? As I understand it, "nillable" in GML means the element may be missing. Is there some other way to cause an element to be conditionally omitted? Tara Andrea Aime wrote: On 21/09/2010 04:14, Tara Athan wrote:I have been attempting to use ECQL expressions in an app-schema mapping file, but am having trouble with the syntax. The link given in the Geoserver manual http://udig.refractions.net/confluence/display/EN/Common+Query+Language is broken.The only ECQL reference I have been able to find is http://docs.codehaus.org/display/GEOTOOLS/ECQL+Parser+Design#ECQLParserDesign-ECQLGrammar which does not give a list of functions. The pages http://docs.geoserver.org/stable/en/user/data/app-schema/mapping-file.html#cql and http://docs.geoserver.org/stable/en/user/data/app-schema/vocab-functions.html#app-schema-vocab-functions give examples of two functions, and hint at the existence of a third, "if_then_else", which is the one I think I want.The full list of functions is not ECQL specific, you can find it here: http://docs.geoserver.org/2.0.x/en/user/filter/index.html Cheers Andrea -- Tara Athan Owner, Athan Ecological Reconciliation Services tara_athan at alt2is.com 707-272-2115 (cell, preferred) 707-485-1198 (office) 249 W. Gobbi St. #A Ukiah, CA 95482 |
------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users