topic cmis search returns unexpected result. in Alfresco Archive

cmis search returns unexpected result.

begunrom — Mon, 03 Mar 2014 14:38:09 GMT

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">

Re: cmis search returns unexpected result.

kaynezhang — Mon, 03 Mar 2014 15:17:23 GMT

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>
‍‍‍‍‍‍‍‍‍‍‍

Re: cmis search returns unexpected result.

begunrom — Mon, 03 Mar 2014 15:52:36 GMT

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.

Re: cmis search returns unexpected result.

begunrom — Mon, 03 Mar 2014 16:03:54 GMT

Hi,

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

thanks.