AnsweredAssumed Answered

Querying field with balnk space

Question asked by agz on Jul 5, 2013
Hi all,
I have defined my custom aspect with the metadata

<property name="gedal:contact">
      <type>d:text</type>
      <mandatory>true</mandatory>
      <multiple>false</multiple>
</property>


I have a document that haev gedal:contact="first name last name"

When I try to query this field, the LIKE predicate ignore blank spaces and give me no results.

In detail:

SELECT P.* FROM cmis:document as D JOIN gedal:customAspect AS P ON D.cmis:objectId = P.cmis:objectId WHERE P.gedal:contact LIKE '%first%'

1 result (OK)



SELECT P.* FROM cmis:document as D JOIN gedal:customAspect AS P ON D.cmis:objectId = P.cmis:objectId WHERE P.gedal:contact LIKE '%first %'

0 result (!!!)



SELECT P.* FROM cmis:document as D JOIN gedal:customAspect AS P ON D.cmis:objectId = P.cmis:objectId WHERE P.gedal:contact LIKE '%first name%'

0 result (!!!)



SELECT P.* FROM cmis:document as D JOIN gedal:customAspect AS P ON D.cmis:objectId = P.cmis:objectId WHERE P.gedal:contact LIKE '%first%name%'

0 result (!!!)

And with the exact value

SELECT P.* FROM cmis:document as D JOIN gedal:customAspect AS P ON D.cmis:objectId = P.cmis:objectId WHERE P.gedal:contact LIKE '%first name last name%'

0 result (!!!)

Why? :(
I espect 1 result from all queries

I noticed the same problem with the field <strong>cm:author</strong>

I hope someone can help me.
Thanks in advance!

Outcomes