cmis search returns unexpected result.

[begunrom]

I execute the following cmis search
<blockcode>
select A.*, F.* FROM pmroductTypeAspect AS A JOIN pm:drawing AS F ON A.cmisbjectId = F.cmisbjectId where A.pmroductType ='—11'
</blockcode>

productTypeAspect is defined as
<blockcode>
<aspect name="pmroductTypeAspect">
   <title>Product Type Aspect</title>
   <properties>
      <property name="pmroductType">
         <title>Product Type</title>
         <type>d:text</type>
         <multiple>true</multiple>
      </property>
      <property name="pmroduct">
         <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 pmroductType.
Document 1 –> pmroductType='—11'
Document 2 –> pmroductType='—11.1'
Document 3 –> pmroductType='abc'

If i execute the cmis search as specified above (where A.pmroductType ='—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?

[kaynezhang]

I think the problem is caused by lunene index token mechanism .You can try to define your pmroductType property like following and rebuild index.

      <property name="pm:productType">
         <title>Product Type</title>
         <type>d:text</type>
         <multiple>true</multiple>
              <index enabled="true">
                      <tokenised>both</tokenised>
              </index>

      </property>
‍‍‍‍‍‍‍‍‍‍‍

[begunrom]

Hi,

Thanks for your answer. It did change something… Now nothing is returned.

So unfortunately, this is not the answer to the problem.

Thanks for answering.

[begunrom]

Hi,

I started working. I guess i did not wait long enough.
Now correct results are being returned.

thanks.