Question

Formatted Search will show me the "n" oldest pages.

SpreadsheetPlugin has ways to compare dates.

Has anyone written the search that can go through my web and find all of the pages that are older than a given date? The stale data? The moldy oldies?

Environment

-- VickiBrown - 22 Jan 2008

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

This is soo much easier in TWiki 4.2 with type="query"...

Well, one test that works on 4.1.2 for me is this, just change the web name:

%SEARCH{"META:TOPICINFO.*?date" web="Yourweb" type="regex" format="$percntCALC{$IF($TIME(01 Jan 2007) > $TIME($date), | Yourweb.$topic | $date |,)}$percnt" nonoise="on" order="modified" }%

-- LarsEik - 23 Jan 2008

In TWiki 4.2 I write:

%SEARCH{"info.date <= d2n('2007-01-01')" web="Yourweb" type="query" nonoise="on" order="modified" format="|Yourweb.$topic|$date|" }%

-- LarsEik - 23 Jan 2008

Thank you!

I'll look forward to 4.2 as well.

-- VickiBrown - 02 Feb 2008