topic Re: Sorting ResultSet via SortedResultSet in Alfresco Archive

Sorting ResultSet via SortedResultSet

k_warcaba — Fri, 29 May 2009 10:28:05 GMT

Hi all,I have a problem with sorting ResultSet via SortedResultSet. Here is my code: ResultSet resultSet = searchService.query(storeRef, SearchService.LANGUAGE_LUCENE, query); SearchParameters parameters = new SearchParameters(); String field = "{http://w

Re: Sorting ResultSet via SortedResultSet

rliu — Tue, 02 Jun 2009 05:10:01 GMT

Ha! …. Lucene has roughed me up a couple days and I hope nobody had to go thru the battles I had to go thru.

            
SearchParameters parameters = new SearchParameters();
String field = "{http://www.alfresco.org/model/content/1.0}created";
parameters.addSort(field, false);
‍‍‍‍‍

Try the following:


SearchParameters parameters = new SearchParameters();
String field = "{http://www.alfresco.org/model/content/1.0}created";
parameters.addSort(org.alfresco.repo.search.impl.lucene.QueryParser.escape(field), false);
‍‍‍‍‍

This should work, though, if you want to make life simpler, use the prefix property naming convention:


String field = org.alfresco.repo.search.impl.lucene.QueryParser.escape("@cm:created"); 
‍‍‍

Reference: http://lucene.apache.org/java/2_4_1/api/org/apache/lucene/queryParser/QueryParser.html#escape(java.lang.String)

Re: Sorting ResultSet via SortedResultSet

agrosu — Fri, 26 Nov 2010 09:05:09 GMT

Hi,

Just having the same case.
The problem is the ommission of the "@" in the sort clause.
Old sort
String field = "{http://www.alfresco.org/model/content/1.0}created";
Correct sort:
String field = "@{http://www.alfresco.org/model/content/1.0}created";

Hope that helps