topic Unable to match categories in lucene query in Alfresco Archive

Unable to match categories in lucene query

stevewickii — Tue, 22 Jan 2008 19:24:15 GMT

I am not having any success executing the following query with Alfresco 2.9.0B. This worked in Alfresco 2.1.0 R1.+PARENT:"workspace://SpacesStore/fd22314e-bb01-11dc-862f-f9940e3b6af0" +@cm\:categories:"workspace://SpacesStore/a39d7d01-7103-11dc-9a14-ed64e29c2348"‍‍‍This statement, by itself +PARENT

Re: Unable to match categories in lucene query

rivarola — Wed, 23 Jan 2008 13:49:14 GMT

Hello,

Couldn't you use the PATH query to get the document classified by the category instead of NodeRef value in the property ? Usually to find document against categories we use queries like PATH:"/cm:generalclassifiable/cm:Languages/cm:French/*"

Re: Unable to match categories in lucene query

stevewickii — Wed, 23 Jan 2008 21:55:55 GMT

It takes 35 seconds to execute the query using PATH method with categories.

Re: Unable to match categories in lucene query

stevewickii — Wed, 23 Jan 2008 22:49:52 GMT

This query executes in Alfresco 2.1.0 R1 in less than 1 second and returns 1 document. The same query returns 0 documents in Alfresco 2.9.0B running on a copy of the 2.1.0 database and dir.root.

+PATH:"/app:company_home/cm:FMC/cm:Content/cm:Links/cm:associations/cm:National/*" AND @cm\:categories:"workspace://SpacesStore/a39d7d01-7103-11dc-9a14-ed64e29c2348"‍

Re: Unable to match categories in lucene query

stevewickii — Wed, 23 Jan 2008 23:25:31 GMT

Searching by the categories property actually works in Alfresco 2.9.0B, it just isn't matching categories properties in my existing content.

When I add new content, and assign the category Audience/Consultants to the content, the following query returns the new piece of content very quickly.

+PATH:"/app:company_home/cm:FMC/*" AND @cm\:categories:"workspace://SpacesStore/a39d7d01-7103-11dc-9a14-ed64e29c2348"‍

workspace://SpacesStore/a39d7d01-7103-11dc-9a14-ed64e29c2348 is the node reference for the category Audience/Consultants.

When I execute the following query, i see 5 documents, and each of them has workspace://SpacesStore/a39d7d01-7103-11dc-9a14-ed64e29c2348 in the categories property.

+PATH:"/app:company_home/cm:FMC/*"‍

So, what is wrong with my existing content? Is there something wrong with my indexes? And, how do I fix it?