AnsweredAssumed Answered

Querying aspects -encoding trouble?

Question asked by jba on Oct 27, 2011
Dear all,
I have some odd trouble about querying aspects, it is certainly me forgetting one basic thing or two, but still..

Let's say I have an aspect defined this way -with a constraint.

<constraints>
      <constraint name="re:status_constraint" type="LIST">
       <parameter name="allowedValues">
        <list>
<value>I.A.2.3. Asie</value>
<value>I.A.1.1. Conseil mondial de l'énergie</value>
</list>
       </parameter>      
      </constraint>
      </constraints>

<aspect name="re:status">
       <title>Status</title>
        <properties>
         <property name="re:status">
          <title>Status</title>
          <type>d:text</type>
          <constraints>
           <constraint ref="re:status_constraint" />
          </constraints>  
         </property>   
        </properties>  
      </aspect>

Then this query works :

select d.*, o.* from cmis:document as d join re:status as o on d.cmis:objectid = o.cmis:objectid where o.re:status like '%mondial%'
but this one (and variants using spaces, dots and accented characters) doesn't

select d.*, o.* from cmis:document as d join re:status as o on d.cmis:objectid = o.cmis:objectid where o.re:status = 'I.A.2.3. Asie'

I thought that my query should be encoded in  ISO 9075, but a code like that doesn't work either


select d.*, o.* from cmis:document as d join re:status as o on d.cmis:objectid = o.cmis:objectid where o.re:status = '%Conseil_x0020_mondial%'

Any idea? wrong encoding like I suppose?..
Thanks for viewing
JB

Outcomes