topic 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/289285#M242415 <HTML><HEAD></HEAD><BODY><SPAN>Below is a sinppet of code </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;StringBuffer sbQuery = new StringBuffer();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sbQuery.append("TYPE:\"cm:person\"");<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (!StringUtils.isBlank(filter)) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sbQuery.append(" AND ALL:\"" + filter + "*\"");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SearchService searchService = serviceRegistry.getSearchService();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SearchParameters sp = new SearchParameters();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.addStore(StoreRef.STORE_REF_WORKSPACE_SPACESSTORE);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.setLanguage(SearchService.LANGUAGE_LUCENE);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.addTextAttribute("@" + ContentModel.PROP_LASTNAME.toString());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.setQuery(sbQuery.toString());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.setMaxItems(100);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.addSort("@" + ContentModel.PROP_LASTNAME.toString(), true);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.addSort("@" + ContentModel.PROP_FIRSTNAME.toString(), true);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.addSort("@" + ContentModel.PROP_USERNAME.toString(), true);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ResultSet resultsset = null;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;try {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;resultsset = searchService.query(sp);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// ResultSet resultsset = searchService.query(SSICConstants.STORE,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// SearchService.LANGUAGE_LUCENE, sbQuery.toString());<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Iterator&lt;ResultSetRow&gt; itr = resultsset.iterator();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while (itr.hasNext()) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ResultSetRow currentRow = itr.next();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;currentRow.getNodeRef() // RETURNS as Expected every time<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; currentRow.getValues() //RETURNS NULL if the above var filter is not null, returns as expect if filter is null<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} finally {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (resultsset != null) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;resultsset.close();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<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>‍</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 /><BR /><SPAN>Issue is if the "filter" is empty so that is does not append the "AND ALL:" to the query the getValues returns all of the properties of the node.&nbsp; However if the filter is set and it still returns the expected nodes, the getValues for those nodes is null.</SPAN><BR /><BR /><SPAN>Other note is if I do the same query without using SearchParameters and just doing it from the query(x,x,x) method the getValues returns as expected.</SPAN><BR /><BR /><SPAN>P.S.&nbsp; I know I should use parameterized query, still trying to figure out how to set the QName on that.&nbsp; If anyone has examples of using that would be helpful.</SPAN></BODY></HTML> Thu, 13 Jun 2013 20:52:47 GMT hagak 2013-06-13T20:52:47Z 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