topic Query not return the result correctly in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/query-not-return-the-result-correctly/m-p/35917#M18915 <HTML><HEAD></HEAD><BODY><SPAN>This is the query:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>ID:"workspace://SpacesStore/b96b72c1-c9f8-11da-984f-3d735fa1fd62" OR ID:"workspace://SpacesStore/b98674d6-c9f8-11da-984f-3d735fa1fd62" OR ID:"workspace://SpacesStore/b7ef5ad6-c9f8-11da-984f-3d735fa1fd62"<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>This query find 3 ID (unique for all Nodes) and the query will should return 3 Nodes, but the query return 9 !!</SPAN><BR /><BR /><SPAN>I i find in the query by 4 ID's, the query return 12 results!</SPAN><BR /><BR /><SPAN>Allways return 3 results for a ID.</SPAN><BR /><BR /><SPAN>This is the code:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory.getRepositoryService();<BR />String pathQuery="ID:\"" + idQuery.toString() + "\"" ;<BR />Query queryCategory = new Query(QueryLanguageEnum.lucene, pathQuery);<BR />QueryResult queryResultCat = repositoryService.query(STORE, queryCategory, false);<BR />ResultSet resultSetCat = queryResultCat.getResultSet();<BR />ResultSetRow rowsCat[] = resultSetCat.getRows();<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Where idQuery is above.</SPAN><BR /><BR /><SPAN>Any ideas?</SPAN></BODY></HTML> Thu, 20 Apr 2006 15:23:12 GMT jlbarrera 2006-04-20T15:23:12Z Query not return the result correctly https://connect.hyland.com/t5/alfresco-archive/query-not-return-the-result-correctly/m-p/35917#M18915 This is the query:ID:"workspace://SpacesStore/b96b72c1-c9f8-11da-984f-3d735fa1fd62" OR ID:"workspace://SpacesStore/b98674d6-c9f8-11da-984f-3d735fa1fd62" OR ID:"workspace://SpacesStore/b7ef5ad6-c9f8-11da-984f-3d735fa1fd62"‍This query find 3 ID (unique for all Nodes) and the query will should return 3 Thu, 20 Apr 2006 15:23:12 GMT https://connect.hyland.com/t5/alfresco-archive/query-not-return-the-result-correctly/m-p/35917#M18915 jlbarrera 2006-04-20T15:23:12Z Re: Query not return the result correctly https://connect.hyland.com/t5/alfresco-archive/query-not-return-the-result-correctly/m-p/35918#M18916 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>The index may contain several entries using ID (some internal structure to make path indexing better). So for folders you will get one entry for the node and as many more as there are unique paths to the folder.</SPAN><BR /><BR /><SPAN>You can solve your issue by </SPAN><BR /><BR /><SPAN> 1) also looking for nodes +ISNODE:*</SPAN><BR /><SPAN> </SPAN><BR /><SPAN> 2) also looking for a specific type +TYPE:"cm:content"</SPAN><BR /><BR /><SPAN>See </SPAN><A href="http://wiki.alfresco.com/wiki/Search" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Search</A><BR /><SPAN>See </SPAN><A href="http://wiki.alfresco.com/wiki/Search#Finding_Nodes_By_Type" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Search#Finding_Nodes_By_Type</A><SPAN> </SPAN><BR /><BR /><SPAN>I forgot to add this to the search documentation.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Fri, 21 Apr 2006 08:27:30 GMT https://connect.hyland.com/t5/alfresco-archive/query-not-return-the-result-correctly/m-p/35918#M18916 andy 2006-04-21T08:27:30Z Re: Query not return the result correctly https://connect.hyland.com/t5/alfresco-archive/query-not-return-the-result-correctly/m-p/35919#M18917 <HTML><HEAD></HEAD><BODY><SPAN>OK Thanks! Now all worked fine&nbsp; <span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:">😎</span></SPAN></BODY></HTML> Fri, 21 Apr 2006 09:28:50 GMT https://connect.hyland.com/t5/alfresco-archive/query-not-return-the-result-correctly/m-p/35919#M18917 jlbarrera 2006-04-21T09:28:50Z