cmis search returns unexpected result.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2014 09:38 AM
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?
<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?
Labels:
- Labels:
-
Archive
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2014 10:17 AM
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>
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2014 10:52 AM
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.
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2014 11:03 AM
Hi,
I started working. I guess i did not wait long enough.
Now correct results are being returned.
thanks.
I started working. I guess i did not wait long enough.
Now correct results are being returned.
thanks.