[GeoNetwork-devel] issue on CSW search filtering on organisationName

GeoNetwork GeoNetwork Developer
1

Dear list,

I am using Geonetwork 2.6.4
I have a weird issue on a CSW query filtering on organisationName

Here is the context :
# I know the organisationName appearing in my metadata sheets using a GetDomain query
<csw:GetDomain xmlns:csw="http://www.opengis.net/cat/csw/2.0.2&quot; service="CSW">
<csw:PropertyName>organisationName</csw:PropertyName>
</csw:GetDomain>

# But when I query on some of the returned organisation. Those having special char like l' or ô in French don't return any metadata. Impossible given that the GetDomain returns something.

# The query :
<csw:GetRecords xmlns:csw="http://www.opengis.net/cat/csw/2.0.2&quot; service="CSW" version="2.0.2" resultType="results" startPosition="1" maxRecords="1000">
<csw:Query typeNames="csw:Record">
<csw:ElementName>dc:identifier</csw:ElementName>
<csw:ElementName>dc:title</csw:ElementName>
<csw:ElementName>dc:subject</csw:ElementName>
<csw:ElementName>dc:description</csw:ElementName>
<csw:ElementName>dc:date</csw:ElementName>
<csw:ElementName>dc:URI</csw:ElementName>
<ogc:SortBy xmlns:ogc="http://www.opengis.net/ogc&quot;&gt;
<ogc:SortProperty>
<ogc:PropertyName>relevance</ogc:PropertyName>
<ogc:SortOrder>D</ogc:SortOrder>
</ogc:SortProperty>
</ogc:SortBy>
<csw:Constraint version="1.0.0">
<ogc:Filter xmlns:ogc="http://www.opengis.net/ogc&quot;&gt;
<ogc:And>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>organisationName</ogc:PropertyName>
<ogc:Literal>Office International de l'eau</ogc:Literal>
</ogc:PropertyIsEqualTo>
<ogc:Intersects>
<ogc:PropertyName>ows:BoundingBox</ogc:PropertyName>
<gml:Box xmlns:gml="http://www.opengis.net/gml&quot;&gt;
<gml:coordinates decimal="." cs="," ts=" ">-6,41 10,51</gml:coordinates>
</gml:Box>
</ogc:Intersects>
</ogc:And>
</ogc:Filter>
</csw:Constraint>
</csw:Query>
</csw:GetRecords>

# I thought it was an encoding issue so I tried replacing PropertyIsEqualTo with :
<ogc:PropertyIsLike wildCard="%" singleChar="_"
escapeChar="\">
<ogc:PropertyName>organisationName</ogc:PropertyName>
<ogc:Literal>Office International de l%</ogc:Literal>
</ogc:PropertyIsLike>

and it does not work better (db is in MySQL : utf8_general_ci)

# catalina.out does not seem to display any encoding issue when logging the query

# Any idea? For an example that works : use BRGM as an organisationName

# My csw address http://services.sandre.eaufrance.fr/geonetwork_CSW/srv/fr/csw

Many thanks
Sylvain