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):

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