topic Re: ResultSetRow.getValues is null for certain queries? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/resultsetrow-getvalues-is-null-for-certain-queries/m-p/289286#M242416 <HTML><HEAD></HEAD><BODY><SPAN>After messing with various knobs, I looked at the useInMemorySort option.&nbsp; So if it uses the inmemorysort because the result set is below the threshold then I get no properties in the ResultSet just the noderef.&nbsp; If the resultset is too large it then does the sort differently and it includes the properties.&nbsp; So if I set setUseInMemorySort(false) it works everytime</SPAN><BR /><BR /><SPAN>This seems like a bug that the resultset changes based on how it decides to do the sort, also kind of defeats the advantage of doing the sort faster inmemory if you then have to go back and fetch the property values of the nodes.</SPAN></BODY></HTML> Fri, 14 Jun 2013 19:25:23 GMT hagak 2013-06-14T19:25:23Z ResultSetRow.getValues is null for certain queries? https://connect.hyland.com/t5/alfresco-archive/resultsetrow-getvalues-is-null-for-certain-queries/m-p/289285#M242415 Below is a sinppet of code &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;StringBuffer sbQuery = new StringBuffer();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sbQuery.append("TYPE:\"cm<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />erson\"");&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (!StringUtils.isBlank(filter)) {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sbQuery.append(" AND ALL:\"" + filter + "*\"");&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SearchService searchService = serviceRegistry.getSearchService();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thu, 13 Jun 2013 20:52:47 GMT https://connect.hyland.com/t5/alfresco-archive/resultsetrow-getvalues-is-null-for-certain-queries/m-p/289285#M242415 hagak 2013-06-13T20:52:47Z Re: ResultSetRow.getValues is null for certain queries? https://connect.hyland.com/t5/alfresco-archive/resultsetrow-getvalues-is-null-for-certain-queries/m-p/289286#M242416 <HTML><HEAD></HEAD><BODY><SPAN>After messing with various knobs, I looked at the useInMemorySort option.&nbsp; So if it uses the inmemorysort because the result set is below the threshold then I get no properties in the ResultSet just the noderef.&nbsp; If the resultset is too large it then does the sort differently and it includes the properties.&nbsp; So if I set setUseInMemorySort(false) it works everytime</SPAN><BR /><BR /><SPAN>This seems like a bug that the resultset changes based on how it decides to do the sort, also kind of defeats the advantage of doing the sort faster inmemory if you then have to go back and fetch the property values of the nodes.</SPAN></BODY></HTML> Fri, 14 Jun 2013 19:25:23 GMT https://connect.hyland.com/t5/alfresco-archive/resultsetrow-getvalues-is-null-for-certain-queries/m-p/289286#M242416 hagak 2013-06-14T19:25:23Z