topic Re: Advanced Lucene Search in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/advanced-lucene-search/m-p/204003#M157133 <HTML><HEAD></HEAD><BODY><SPAN>I suspect this can't be expressed solely in Lucene (it's not as powerful a query language as SQL), but it could be implemented via a combination of Lucene (to find all images where P1="Large") and direct repository traversal (to find the parent folders of the set of images returned by the Lucene query).</SPAN><BR /><BR /><SPAN>Provided this is done in-process (eg. in a Web Script) this should be pretty performant, despite requiring N + 1 atomic operations (1 for the Lucene query + N for the directory lookups).</SPAN><BR /><BR /><SPAN>Cheers,</SPAN><BR /><SPAN>Peter</SPAN></BODY></HTML> Sat, 03 Jan 2009 05:50:09 GMT pmonks 2009-01-03T05:50:09Z Advanced Lucene Search https://connect.hyland.com/t5/alfresco-archive/advanced-lucene-search/m-p/204002#M157132 So the problem we are tackling isL1&nbsp;&nbsp;&nbsp; L2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; L3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1, P2, P3, P4 etc.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1, P2, P3, P4 etc.Where L1, L2, L3 are all folders and I1 in an image (instance) and P1, P2 P3 etc are all aspects. We are looking for a result set of all L3&nbsp; where I* has som Thu, 04 Dec 2008 07:21:59 GMT https://connect.hyland.com/t5/alfresco-archive/advanced-lucene-search/m-p/204002#M157132 tpod2 2008-12-04T07:21:59Z Re: Advanced Lucene Search https://connect.hyland.com/t5/alfresco-archive/advanced-lucene-search/m-p/204003#M157133 <HTML><HEAD></HEAD><BODY><SPAN>I suspect this can't be expressed solely in Lucene (it's not as powerful a query language as SQL), but it could be implemented via a combination of Lucene (to find all images where P1="Large") and direct repository traversal (to find the parent folders of the set of images returned by the Lucene query).</SPAN><BR /><BR /><SPAN>Provided this is done in-process (eg. in a Web Script) this should be pretty performant, despite requiring N + 1 atomic operations (1 for the Lucene query + N for the directory lookups).</SPAN><BR /><BR /><SPAN>Cheers,</SPAN><BR /><SPAN>Peter</SPAN></BODY></HTML> Sat, 03 Jan 2009 05:50:09 GMT https://connect.hyland.com/t5/alfresco-archive/advanced-lucene-search/m-p/204003#M157133 pmonks 2009-01-03T05:50:09Z