acs::SiteNode method get_urls_from_object_id (public)

 <instance of acs::SiteNode> get_urls_from_object_id \
    -object_id object_id 

Defined in packages/acs-tcl/tcl/site-nodes-procs.tcl

Return a list of URLs for site_nodes that have the given object mounted or the empty list if there are none. The URLs are returned in descending order meaning any children will come before their parents. This ordering is useful when deleting site nodes as we must delete child site nodes before their parents.

Switches:

-object_id (required, integer)

Testcases:

No testcase defined.

Source code:

set child_urls [::acs::dc list -prepare integer dbqd..[current method]-all [subst {
    select [acs::dc map_function_name site_node__url(node_id)] as url
    from site_nodes
    where object_id = :object_id
    order by url desc
}]]

Generic XQL file:

packages/acs-tcl/tcl/site-nodes-procs.xql

PostgreSQL XQL file:

packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql

Oracle XQL file:

packages/acs-tcl/tcl/site-nodes-procs-oracle.xql