fs__url (private)

 fs__url revision_id

Defined in packages/file-storage/tcl/file-storage-search-procs.tcl

Parameters:
revision_id (required)
Author:
Jowell S. Sabino <jowellsabino@netscape.net>

Partial Call Graph (max 5 caller/called nodes):
%3 db_1row db_1row (public) fs__url fs__url fs__url->db_1row

Testcases:
No testcase defined.
Source code:

    db_1row fs_get_package_id "
    select f.package_id as package_id
      from fs_root_folders f,
             (select parent.parent_id
         from cr_items parent, cr_items children, cr_revisions r
        where children.item_id = r.item_id
          and r.revision_id = $revision_id
              and children.tree_sortkey
                    between parent.tree_sortkey
                    and     tree_right(parent.tree_sortkey) ) as i
        where f.folder_id = i.parent_id
    "

    db_1row fs_get_url_stub "
        select site_node__url(node_id) as url_stub
        from site_nodes
        where object_id=:package_id
    "

    return "${url_stub}download/index?version_id=$revision_id"
XQL Not present:
Generic, Oracle
PostgreSQL XQL file:
packages/file-storage/tcl/file-storage-search-procs-postgresql.xql

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