topic Re: Lucene -- return nodes that are multi-filed in Alfresco Archive

Lucene -- return nodes that are multi-filed

stevegreenbaum — Thu, 15 Nov 2012 20:48:40 GMT

One of our requirements is the ability to categorize our documents using several category views of the data. Ideally, the categorization would be dynamic and flexible to allow the sub-categories to be moved under different parents and new category trees to be created. We need to be able to respond

Re: Lucene -- return nodes that are multi-filed

mitpatoliya — Fri, 16 Nov 2012 09:02:05 GMT

Well I do not think the same node can have more then one parents I mean one document can not reside under more then on space.
You need to create the another copy in that case.
And also in Query you need to your "OR" rather then "AND" for joining two path queries.

Re: Lucene -- return nodes that are multi-filed

stevegreenbaum — Fri, 16 Nov 2012 13:54:16 GMT

Well I do not think the same node can have more then one parents I mean one document can not reside under more then on space.

Thank you for your input.

Alfresco does support having a node under two folders at the same time. One of the relationships is considered the "primary", which is where the physical document is located. The other relationship is essentially a pointer back to the physical document. This approach was suggested to me by one of the Alfresco engineers for this particular case. The part that is in question is whether two PATHs can be included in one Lucene statement.

I was originally going to handle this situation using a CMIS query, but then found out that subqueries are not supported. Conceptually, that approach would have allowed me to find documents that were in the case folder that were also in the category tree.

I'm not stuck on any particular approach to this problem, just looking for a solution that doesn't require the duplicating of documents or metadata from the case#123 folder down to the node.

I know a lot of the Alfresco team are traveling back from DevCon, but I was hoping that someone might see this – hint: Andy

Re: Lucene -- return nodes that are multi-filed

andy — Tue, 20 Nov 2012 11:30:55 GMT

Hi

You can have as many PATH expression in your lucene query as you like.
I would have to check the spec to see if you can do this in CMIS QL ….(There is no limit in the underlying implementation and you could do it in CONTAINS)

Andy