topic Re: Query Search with space and range date parameter in Alfresco Archive

Query Search with space and range date parameter

ant_batt — Fri, 19 Mar 2010 15:32:24 GMT

Hi to all,I have a problem. I want to search, with Web Service, a content that have a date range (that user insert in input) and are present in a specific space.I have try with this code, but the result is a ResultsSet of content that are present in a space that I don't want…SimpleDateFormat df = Ca

Re: Query Search with space and range date parameter

chooli — Tue, 23 Mar 2010 09:20:46 GMT

Try the following codes, I had the same case like yours in my project


GregorianCalendar gc = new GregorianCalendar();
gc.add(Calendar.MONTH,-1);
String monthAgo = new SimpleDateFormat("yyyy-MM-dd").format(gc.getTime());

String path="+PATH:\"/app:company_home/cm:portale/cm:Istruzione/cm:Contenuti/cm:Home/cm:normativa/*\"";
String range=" +@cm\\:created:[" + monthAgo + "T00:00:00 TO NOW]";
String str=path+range;
Query query = new Query(Constants.QUERY_LANG_LUCENE, str);
QueryResult queryResult = repositoryService.query(STORE, query, false);
‍‍‍‍‍‍‍‍‍‍‍

I didn't test these codes, but it should work

Re: Query Search with space and range date parameter

ant_batt — Tue, 23 Mar 2010 10:32:38 GMT

Thaks chooli,
works fine but I didn't understand what's wrong in my code.

Re: Query Search with space and range date parameter

rscottm — Mon, 29 Mar 2010 21:13:15 GMT

Your problem might have been this line

String range="@cm\\:created:[" + dateI + " TO " + dateF +"]'";

needing to read like this

String range=" +@cm\\:created:[" + dateI + " TO " + dateF +"]'";

? Not sure if it caused the entire problem, but I think the leading space and + are required.

Hope it helps,
scott