news__last_updated (private)

 news__last_updated package_id

Defined in packages/news/tcl/news-procs.tcl

Return the timestamp of the most recent item in this news instance. This proc implements the 'lastUpdated' operation of the 'RssGenerationSubscriber' Service Contract and should not be invoked directly.

Parameters:
package_id (required)
Author:
Dave Bauer <dave@thedesignexperience.org>
Created:
2005-01-22

Testcases:
No testcase defined.
Source code:
    return [db_string get_last_updated {}]
Generic XQL file:
<fullquery name="news__last_updated.get_last_updated">
    <querytext>
        select max(o.last_modified)
        from acs_objects o, cr_news n
        where n.package_id=:package_id
        and o.object_id=n.news_id
        </querytext>
</fullquery>
packages/news/tcl/news-procs.xql

PostgreSQL XQL file:
packages/news/tcl/news-procs-postgresql.xql

Oracle XQL file:
packages/news/tcl/news-procs-oracle.xql

[ hide source ] | [ make this the default ]
Show another procedure: