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 someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is 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" }%
This lists all topics modified before 1 January 2007.
--
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