topic Re: Lucene query to find the 10 last modified nodes. in Alfresco Archive

Lucene query to find the 10 last modified nodes.

jacqueswvdh — Thu, 19 Jul 2007 09:58:13 GMT

Hi all,I need to make a lucene query to find an list of nodes, ordered by modified DESC. I only want the first 10 records back. I am using javascript. This works: model.nodes = search.luceneSearch("@cm\\:modified:[2007-01-17T00:00:00 TO 2007-08-05T00:00:00]");But I would like to do something like

Re: Lucene query to find the 10 last modified nodes.

dhalupa — Thu, 19 Jul 2007 10:19:01 GMT

http://wiki.alfresco.com/wiki/Search

Kind regards,

Denis

Re: Lucene query to find the 10 last modified nodes.

jacqueswvdh — Tue, 24 Jul 2007 13:47:09 GMT

I found the answer. In the .ftl-file:
<#assign newsNodes = companyhome.childrenByLuceneSearch["TYPE:mn\\:newsItem"]?sort_by(["properties","modified"])?reverse >

I am now looking for a way to limit the resultset to the last 10 modified nodes
Of course, this can be done by:

<#list newsNodes as newsNode>
<#if newsNode_index < 10>

but I am sure it is more efficient to have lucen limit her output.