Lucene query for a Date range

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

abirb

I need to incorporate a lucene Serach for docs in a specified location on a particular date range. I have used the following lucene query , but it throws up an error in the response file

500 Description: An error inside the HTTP server which prevented it from fulfilling the request.

Message: Error during processing of the template 'Expression resultset is undefined on line 7, column 8 in SearchDate.post.html.ftl.'. Please contact your system administrator.

the controller file (lucene search)

var nodes = search.luceneSearch("date:\" [2008\-10\-30T00:00:00 TO 2008\-10\-30T00:00:00]);
model.resultset=nodes;‍‍

I guess my query string format is not correct …

<html>
  <body>
    <img src="${url.context}/images/logo/AlfrescoLogo32.png" alt="Alfresco" />
    Date Searched for : PUT THE DATES HERE
    <br>
    <table>
<#list resultset as node>
     <tr>
       <td><img src="${url.context}${node.icon16}"/>
       <td><a href="${url.serviceContext}/api/node/content/${node.nodeRef.storeRef.protocol}/${node.nodeRef.storeRef.identifier}/${node.nodeRef.id}/${node.name?url}">${node.name}</a>
     </tr>
</#list>
    </table>
  </body>
</html>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks in Advance

rivetlogic

Hi,

Try the below code as an example.

var nodes = search.luceneSearch("@cm\\:modified:[2005\-10\-30T00:00:00 TO 2008\-10\-30T00:00:00]");
model.resultset = nodes;

‍‍‍‍‍

Date is not one of the fields that can be searched like PATH,TEXT,ID etc.

The example used in SEARCH API wiki page is (http://wiki.alfresco.com/wiki/Search#The_Search_API)

 @test\:date:[2003\-12\-16T00:00:00 TO 2003\-12\-17T00:00:00]

@test is the  prefix for your model and date is the property.
‍‍‍‍‍

You could search on any property this way ( created,expiryDate etc.)

Best Regards,
Shagul