photo_album::search::photo::url (private)

 photo_album::search::photo::url photo_id

Defined in packages/photo-album/tcl/photo-album-search-procs.tcl

returns a URL for a message to the search package

Parameters:
photo_id (required)
- either a revision_id or an item_id for an album
Author:
Jeff Davis davis@xarg.net
Created:
2004-06-01

Partial Call Graph (max 5 caller/called nodes):
%3 AcsSc.ftscontentprovider.url.pa_photo AcsSc.ftscontentprovider.url.pa_photo (private) photo_album::search::photo::url photo_album::search::photo::url AcsSc.ftscontentprovider.url.pa_photo->photo_album::search::photo::url photo_album::search::photo::register_fts_impl photo_album::search::photo::register_fts_impl (private) photo_album::search::photo::register_fts_impl->photo_album::search::photo::url ad_url ad_url (public) photo_album::search::photo::url->ad_url db_0or1row db_0or1row (public) photo_album::search::photo::url->db_0or1row site_node::get_element site_node::get_element (public) photo_album::search::photo::url->site_node::get_element

Testcases:
No testcase defined.
Source code:
    db_0or1row package {
        SELECT n.node_id, i1.item_id
        FROM cr_items i1, cr_items i2, pa_package_root_folder_map m, site_nodes n
        WHERE m.folder_id = i2.item_id
          and i1.item_id = coalesce((select item_id from cr_revisions where revision_id = :photo_id),:photo_id)
          and n.object_id = m.package_id
          and i1.tree_sortkey between i2.tree_sortkey and tree_right(i2.tree_sortkey)
    }

    return "[ad_url][site_node::get_element -node_id $node_id -element url]photo?photo_id=$item_id"
XQL Not present:
Generic, PostgreSQL, Oracle
[ hide source ] | [ make this the default ]
Show another procedure: