topic Re: Lucene Query with OR Keyword not returing proper result in Alfresco Archive

Lucene Query with OR Keyword not returing proper result

himvj — Fri, 13 May 2011 10:20:04 GMT

I want to write a lucene query to serach contents in alfresco repository my Query is like belowfilename = "suppliername";query.statement = "PATH:\"/app:company_home/st:sites/cmrocessing/cm:documentLibrary/cm:AAK/*\" AND TYPE:\"{http://www.alfresco.org/model/content/1.0}content\" OR @my\\:first_s

Re: Lucene Query with OR Keyword not returing proper result

loftux — Fri, 13 May 2011 10:27:12 GMT

What if you try with parentheses?
Something like

query.statement = "PATH:\"/app:company_home/st:sites/cm:processing/cm:documentLibrary/cm:AAK/*\" AND ( TYPE:\"{http://www.alfresco.org/model/content/1.0}content\" OR @my\\:first_supplierInvoice_comAsp1TransRef:\"" + filename + "\" OR @my\\:first_supplierInvoice_supName:\"" + filename + "\" OR @my\\:first_supplierInvoice_comAsp1Date:\"" + filename + "\")";‍

Where you put the parentheses is of course a matter of what you want OR:ed.

Re: Lucene Query with OR Keyword not returing proper result

himvj — Fri, 13 May 2011 10:37:50 GMT

What if you try with parentheses?
Something like

query.statement = "PATH:\"/app:company_home/st:sites/cm:processing/cm:documentLibrary/cm:AAK/*\" AND ( TYPE:\"{http://www.alfresco.org/model/content/1.0}content\" OR @my\\:first_supplierInvoice_comAsp1TransRef:\"" + filename + "\" OR @my\\:first_supplierInvoice_supName:\"" + filename + "\" OR @my\\:first_supplierInvoice_comAsp1Date:\"" + filename + "\")";‍

Where you put the parentheses is of course a matter of what you want OR:ed.

I tried your suggesation that but still it is showing all the contents in that folder. I want only the contents matching any of the metadata.

Re: Lucene Query with OR Keyword not returing proper result

himvj — Fri, 13 May 2011 10:43:07 GMT

I tried your suggesation that but still it is showing all the contents in that folder. I want only the contents matching any of the metadata.

Re: Lucene Query with OR Keyword not returing proper result

loftux — Fri, 13 May 2011 10:44:18 GMT

That is correct if you look at the query, any content will match TYPE
Try this

query.statement = "PATH:\"/app:company_home/st:sites/cm:processing/cm:documentLibrary/cm:AAK/*\" AND TYPE:\"{http://www.alfresco.org/model/content/1.0}content\" AND (@my\\:first_supplierInvoice_comAsp1TransRef:\"" + filename + "\" OR @my\\:first_supplierInvoice_supName:\"" + filename + "\" OR @my\\:first_supplierInvoice_comAsp1Date:\"" + filename + "\")";‍

Re: Lucene Query with OR Keyword not returing proper result

himvj — Fri, 13 May 2011 11:10:54 GMT

yes it is working fine thanks a lot Loftux

Thanks