topic Lucene query Association. in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/lucene-query-association/m-p/234185#M187315 <HTML><HEAD></HEAD><BODY><SPAN>Hi Guys, </SPAN><BR /><SPAN>This question is about the lucene query syntax, for getting the association. so imagine a situation like this one.</SPAN><BR /><SPAN>var documentQuery = search.luceneSearch("+(TYPE:\"rsi:documentGuest\") PATH:\"/app:company_home//*\"");</SPAN><BR /><SPAN>This query return to me an array of documentGuest belong to the company home.</SPAN><BR /><SPAN>The documentGuest type has one association call rsi:assigned. to another type :rsi:documentAssigned</SPAN><BR /><SPAN>My ideal goal is to modify this query to search also for the name of&nbsp; target name of the association.</SPAN><BR /><BR /><SPAN>Until now the only way is to loop for all resultSet like :</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />function getMyDocument(documentGuest,target,guestName){<BR />&nbsp;&nbsp;&nbsp;var docArray = new Array();<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;var internalIndex = 0;<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;for (var i = 0; i &lt; documentGuest.length; i++){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;if(documentGuest[i].assocs[target] != null){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var assocstarget = documentGuest[i].assocs[target];<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(var x = 0;x &lt; assocstarget.length;x++){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(assocstarget[x].properties.name == guestName){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;docArray[internalIndex] = documentGuest[i];<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;internalIndex++;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;return docArray;<BR />&nbsp;&nbsp;&nbsp;<BR />}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>But it is clearly the worste scenario in terms of performance. I really appreciate if someone can help me.</SPAN><BR /><SPAN>I ve try to red the documentation </SPAN><A href="http://wiki.alfresco.com/wiki/Search" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Search</A><SPAN> but without success.</SPAN><BR /><BR /><SPAN>In the end if with lucene could be impossible do that maybe using xpath a solution can exist. </SPAN><BR /><BR /><BR /><SPAN>Thanks a lot guys</SPAN></BODY></HTML> Thu, 20 Aug 2009 09:18:38 GMT joksy 2009-08-20T09:18:38Z Lucene query Association. https://connect.hyland.com/t5/alfresco-archive/lucene-query-association/m-p/234185#M187315 Hi Guys, This question is about the lucene query syntax, for getting the association. so imagine a situation like this one.var documentQuery = search.luceneSearch("+(TYPE:\"rsi:documentGuest\") PATH:\"/app:company_home//*\"");This query return to me an array of documentGuest belong to the company ho Thu, 20 Aug 2009 09:18:38 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-query-association/m-p/234185#M187315 joksy 2009-08-20T09:18:38Z Re: Lucene query Association. https://connect.hyland.com/t5/alfresco-archive/lucene-query-association/m-p/234186#M187316 <HTML><HEAD></HEAD><BODY><SPAN>To accomplish this use case you'd need two things:</SPAN><BR /><OL style="list-style-type:decimal;"><LI>Associations being indexed into Lucene</LI><BR /><LI>Support for projection in Lucene queries</LI></OL><SPAN>Unfortunately Alfresco/Lucene don't support either of these things, so your solution below is an appropriate approach, and your focus should be on optimising that code.&nbsp; Have you benchmarked it, and if so what kind of results are you seeing?</SPAN><BR /><BR /><SPAN>Cheers,</SPAN><BR /><SPAN>Peter</SPAN></BODY></HTML> Sun, 23 Aug 2009 15:23:36 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-query-association/m-p/234186#M187316 pmonks 2009-08-23T15:23:36Z