topic lucene search for one file in Alfresco Archive

lucene search for one file

mangar — Thu, 08 Jul 2010 03:49:16 GMT

I am trying to add/update a file in Alfresco. In order to do this I need to see if the file is already in alfresco so I can choose either CMLCreate vs CMLUpdate. I have been through the wiki tutorial, and i try this search:+PATH:"/app:company_home/cmperations/cm:Reports/cm:myReport"+@cm\:name:"my

Re: lucene search for one file

openpj — Thu, 08 Jul 2010 10:29:17 GMT

You have to add for your PATH token this string "/*" to allow Lucene to search for all the child nodes in that space:


String luceneQuery = "+PATH:\"/app:company_home/cm:Operations/cm:Reports/cm:myReport/*\" +@cm\\:name:\"myReport.xls\"";
‍‍‍

You have to encode all the space names in the ISO 9075 format, this because Alfresco store paths in that format.
Try to encode the Lucene query in this way:


String luceneQuery = "+PATH:\"/app:company_home/cm:"+ISO9075.encode("Operations")+"/cm:"+ISO9075.encode("Reports")+"/cm:"+ISO9075.encode("myReport")+"/*\" +@cm\\:name:\"myReport.xls\"";
‍‍‍

Hope this helps.

Re: lucene search for one file

mangar — Thu, 08 Jul 2010 14:10:57 GMT

Thank you so much! Without that * I was looking for a specific directory with a filename, never going to happen.

Everything works great, thank you!