[fdo-users] Different filter behaviour with King.Oracle

Andreas Morf a.morf at fkl.ch
Tue Sep 23 09:45:52 EDT 2008


No, unfortunately, the LIKE operator without '%' (<Filter>STATUS LIKE
'rechtskräftig'</Filter> ) doesn't work either...

In my opinion this seems to be a bug.

Andreas

> -----Original Message-----
> From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-
> bounces at lists.osgeo.org] On Behalf Of Gavin Cramer
> Sent: Tuesday, September 23, 2008 3:37 PM
> To: FDO Users Mail List
> Subject: RE: [fdo-users] Different filter behaviour with King.Oracle
> 
> Does the "LIKE" operator work if no percent '%' is added to the
> matching string?  Perhaps there is some difference in how the LIKE and
> = operators handle certain character sets on Oracle.
> 
> Gavin
> 
> 
> -----Original Message-----
> From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-
> bounces at lists.osgeo.org] On Behalf Of Andreas Morf
> Sent: Tuesday, September 23, 2008 7:55 AM
> To: fdo-users at lists.osgeo.org
> Subject: [fdo-users] Different filter behaviour with King.Oracle
> 
> Hi all,
> when applying the following filter to a SDF layer the symbolization is
> working as expected: <Filter>STATUS = 'rechtskräftig'</Filter>
> 
> after importing the same data to oracle, the same same AreaRule results
> in
> no data shown... changing the filter to <Filter>STATUS LIKE
> 'rechtskräftig%'</Filter> everything is shown again.
> 
> Should this be considered as a bug or is this an expected behavior?
> 
> Andreas Morf
> 
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users



More information about the fdo-users mailing list