news__url (private)

 news__url object_id

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

Returns the URL for specified news object. This proc implements the 'url' operation of the 'FtsContentProvider' Service Contract and should not be invoked directly.

Parameters:

object_id

Author:

Robert Locke

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

Testcases:

No testcase defined.

Source code:

    db_1row get {}
    set package_url [apm_package_url_from_id $package_id]
    return "[ad_url]${package_url}item/$item_id"

Generic XQL file:

<fullquery name="news__url.get">
    <querytext>
	select distinct r.item_id, n.package_id
        from cr_revisions r, cr_news n
        where (r.revision_id=:object_id or r.item_id = :object_id)
          and r.revision_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