Lucene Category Search in Archieve store

[patil]

Hi,

Can somebody tell whether the category search is supported or not in the Archieve store of Alfresco?

(  ( PATH:"/cm:categoryRoot/cm:generalclassifiable/cm:Languages/cm:English//*"   ) ) AND (+@\{suth.blm.model\}invoiceNumber:"123"  +@\{http\://www.alfresco.org/model/content/1.0\}created:[2010\-11\-08T11\:45\:00 TO 2011\-12\-08T11\:45\:00] +@\{http\://www.alfresco.org/model/content/1.0\}content.mimetype:text/html AND (( TYPE:"suth:type_invoice"  AND ((@\{http\://www.alfresco.org/model/content/1.0\}name:'content" @\{http\://www.alfresco.org/model/content/1.0\}name:'patil" @\{http\://www.alfresco.org/model/content/1.0\}name:'Key3value" @\{http\://www.alfresco.org/model/content/1.0\}name:'fileName" @\{http\://www.alfresco.org/model/content/1.0\}name:'content" @\{http\://www.alfresco.org/model/content/1.0\}name:'patil" @\{http\://www.alfresco.org/model/content/1.0\}name:'Key3value" @\{http\://www.alfresco.org/model/content/1.0\}name:'fileName" @\{http\://www.alfresco.org/model/content/1.0\}name:'content" @\{http\://www.alfresco.org/model/content/1.0\}name:'patil" @\{http\://www.alfresco.org/model/content/1.0\}name:'Key3value" @\{http\://www.alfresco.org/model/content/1.0\}name:'fileName" ) (TEXT:"content" TEXT:"patil" TEXT:"Key3value" TEXT:"fileName" TEXT:"content" TEXT:"patil" TEXT:"Key3value" TEXT:"fileName" TEXT:"content" TEXT:"patil" TEXT:"Key3value" TEXT:"fileName" )))))


Thanks,
Patil
Cignex Technologies
Bangalore

[afaust]

Hello,

I must say, that is a hell of a Lucene query with a lot of apparent redundancies.

1) Shouldn't your category PATH clause look like this: PATH:"/cm:generalclassifiable/cm:Languages/cm:English//*" (based on the documentation in the wiki and my own experience)
2) Category search should be supported in any content store. At least that is what I take from looking at the Alfresco indexer and node service implementation. As long as the classification of the node survives the archival process, the indexer will use the category NodeRefs and construct the paths up to the categoryRoot for the lucene index.

I have actually not yet tried to classify and search an archived node though…

Regards

[andy]

Hi

The archive store is queryable, However, the catagory roots are held in a different store so category queries will fail.
You can not query over multiple stores (technically this is not too hard but has never got on the list)
You would have to create categories in the archive store or use some kind of custom tagging.
The catageory links will be there - so you could build a query to look for them by node ref ….

Andy