AnsweredAssumed Answered

cmis search returns unexpected result.

Question asked by begunrom on Mar 3, 2014
Latest reply on Mar 3, 2014 by begunrom
I execute the following cmis search
<blockcode>
select A.*, F.* FROM pm:productTypeAspect AS A JOIN pm:drawing AS F ON A.cmis:objectId = F.cmis:objectId where A.pm:productType ='—11'
</blockcode>

productTypeAspect is defined as
<blockcode>
<aspect name="pm:productTypeAspect">
   <title>Product Type Aspect</title>
   <properties>
      <property name="pm:productType">
         <title>Product Type</title>
         <type>d:text</type>
         <multiple>true</multiple>
      </property>
      <property name="pm:product">
         <title>Product</title>
         <type>d:text</type>
         <multiple>true</multiple>
      </property>
      <property name="pm:item">
         <title>Item</title>
         <type>d:text</type>
         <multiple>true</multiple>
      </property>
   </properties>
</aspect>
</blockcode>

In Alfresco i have a number of documents that have a value set for pm:productType.
Document 1 –> pm:productType='—11'
Document 2 –> pm:productType='—11.1'
Document 3 –> pm:productType='abc'

If i execute the cmis search as specified above (where A.pm:productType ='—11'), the result contains 2 documents (doc 1 and doc 2), while i only expected doc 1. I did not want '—11.1' to be returned.

How can i solve this?

Outcomes