Re: [Geoserver-users] ECQL for app-schema- reference?

2010-09-22 Thread Rini Angreani
Hmm I thought I had to do some special handlings for Expression.NIL to cater for polymorphism. Didn't think it'd work for normal sourceExpression, I can't remember what I did but maybe it was already working.. anyway that's good :D. I used Expression.NIL because the ECQL parser in app-schema can't

Re: [Geoserver-users] ECQL for app-schema- reference?

2010-09-21 Thread Tara Athan
This works- the property is omitted for theĀ  appropriate cases. An internet search for _expression_.Nil turned up this link: http://docs.geoserver.org/trunk/en/user/data/app-schema/polymorphism.html#null-or-missing-value with example: if_then_else(isNull(VALUE), _expression_.NIL, 'gsml:CGI_

Re: [Geoserver-users] ECQL for app-schema- reference?

2010-09-21 Thread Ben Caradoc-Davies
Try: if_then_else(equalTo(CAT_DESC, 'No Name'), Expression.Nil, CAT_DESC) I found this in Rini's polymorphism.xml (used in PolymorphismWfsTest, in the feature with id=f4) but I have no idea how she found it! If it works, we should document it. xs:nillable means that an element with a non-empt

Re: [Geoserver-users] ECQL for app-schema- reference?

2010-09-21 Thread Tara Athan
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 if_then_else(equalTo(CAT_DESC, 'No Name'), 'NULL', CAT_DESC) This does not if_then_else(equalTo(CAT_DESC, 'No Name'), NULL, CAT_DESC) Am

Re: [Geoserver-users] ECQL for app-schema- reference?

2010-09-21 Thread Andrea Aime
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 onl

Re: [Geoserver-users] ECQL for app-schema- reference?

2010-09-20 Thread Ben Caradoc-Davies
On 21/09/10 10: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. This is the

[Geoserver-users] ECQL for app-schema- reference?

2010-09-20 Thread Tara Athan
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 ht