lucene search for one file

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

mangar

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:"myReport.xls"
(yes, the directory is called myReport, and in that space, the file myReport.xls resides.)

it returns nothing, but it's there. I can see it.

I know the path and the name of the file, what is the correct lucene search to return a ResultSet for that file?

Alternatively, is there any code example that would do this:

ParentReference contentReference = new ParentReference(storeRef,null,path,ASSOC_CONTAINS,ASSOC_CONTAINS);
CMLCreate createDoc = new CMLCreate("ref1", contentReference, null, null, null, Constants.createQNameString(NAMESPACE, "report"), contentProps);
cml.setCreate(new CMLCreate[]{createDoc});
UpdateResult[] result = WebServiceFactory.getRepositoryService().update(cml);
Reference newContentNode = result[0].getDestination();
ContentFormat  format = new ContentFormat("application/excel", "UTF-8");
WebServiceFactory.getContentService().write(newContentNode, Constants.PROP_CONTENT, bytes, format);‍‍‍‍‍‍‍

without that annoying  "Duplicate child name not allowed"

openpj

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.