[TYPO3] Last updated on a page

[Nino Katic]

"Dmitry Dulepov [typo3]" <dmitry at typo3.org> wrote in message 
news:mailman.1.1201367851.31843.typo3-english at lists.netfielders.de...
> Hi!
>
> Nino Katic wrote:
>> Yes, i saw that field in table pages but i guess it gets updated only 
>> when you do some changes on a page.. ie. you add/delete some content on a 
>> page or edit page preferences. This is not very usefull because content 
>> is usually updated not the page itself. Further, i have tt_news plugin on 
>> a page that displays news records from sys folder. When someome 
>> adds/deletes/updates news record in sysfolder last update should also 
>> change. I'm not sure if this can be done? Thx.
>
> Yes, it can. You need CONTENT TS object. Select tstamp field for tt_news 
> record from that sysfolder, order by tstamp (descending), limit to 1. 
> Output this field formatting it as datetime (see stdWrap for details). 
> This will be your 'last updated' value.

Can you help me a bit with this.. I wrote this:

  10 = CONTENT
  10 {
    table = tt_news
    select {
      pidInList = 17     # this is the pid of my sys folder
      orderBy = tstamp descdening
      selectFields = tstamp
      limit = 1
    }
  }

subparts.lastupdate < 10

but it doesn't work :-( Thx.

Nino