news__last_updated

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

Author:

Dave Bauer <dave@thedesignexperience.org>

Created:

2005-01-22

Partial Call Graph (max 5 caller/called nodes):

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 ]