topic Re: luceneDateRange does not work in Alfresco Enterprise 4.1.2 in Alfresco Archive

luceneDateRange does not work in Alfresco Enterprise 4.1.2

ayubalfresco — Tue, 05 Mar 2013 14:07:03 GMT

Hi,I am trying to run the below query in node browser, however it does not seem to show the result. Could some one point what's the issue ?below is the query:<ode>PATH:"/app:company_home/st:sites/cm:ita/cm:documentLibrary/cm:HR_x0020_Department/*" AND (@cm\:created: \$\{luceneDateRange(yesterd

Re: luceneDateRange does not work in Alfresco Enterprise 4.1.2

afaust — Wed, 06 Mar 2013 09:01:00 GMT

Hello,

you can't use luceneDateRange in a node browser query. The expression ${luceneDateRange(yesterday, "P12D")} is a FreeMarker expression that needs to be evaluated BEFORE it is submitted to the search service. It only works in specific, bean-defined scheduled actions of the type CronScheduledQueryBasedTemplateActionDefinition as far as I know.

Regards
Axel

Re: luceneDateRange does not work in Alfresco Enterprise 4.1.2

mitpatoliya — Wed, 06 Mar 2013 11:27:21 GMT

Your query should be

PATH:"/app:company_home/st:sites/cm:ita/cm:documentLibrary/cm:HR_x0020_Department/*" AND (@cm\:created: [2011\-12\-16T00:00:00 TO 2013\-12\-17T00:00:00])

Something like this

check out this
http://wiki.alfresco.com/wiki/Search#Range_Queries

Re: luceneDateRange does not work in Alfresco Enterprise 4.1.2

ayubalfresco — Wed, 06 Mar 2013 12:12:00 GMT

I also tried to put the query in scheduled action service however it does not bring any records which are older than 12 days. The rage query works however the dates are hardcoded. I want to query documents which are older than X number of days. Any other alternatives ?

Re: luceneDateRange does not work in Alfresco Enterprise 4.1.2

mitpatoliya — Fri, 08 Mar 2013 09:53:23 GMT

You can do it in this query as follow


Date d= new Date();   
Calendar c = Calendar.getInstance();
c.setTime(d);
c.add(Calendar.DATE, -days);
d.setTime( c.getTime().getTime() );
SimpleDateFormat dt = new SimpleDateFormat("yyyyy\-mm\-ddThh:mm:ss"); 

String formateddate=dt.format(d);
PATH:"/app:company_home/st:sites/cm:ita/cm:documentLibrary/cm:HR_x0020_Department/*" AND (@cm\:created: [MIN TO formateddate])
‍‍‍‍‍‍‍‍‍‍‍

Something like this

Re: luceneDateRange does not work in Alfresco Enterprise 4.1.2

ayubalfresco — Fri, 08 Mar 2013 11:29:06 GMT

Can I use that code in schedule action xml file ?

Re: luceneDateRange does not work in Alfresco Enterprise 4.1.2

mitpatoliya — Mon, 11 Mar 2013 06:14:23 GMT

Place this code in script file and invoke that script file in scheduled action execution.