dir_app_group_info (public)

 dir_app_group_info

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

Return a list containing the group_id (lindex 0) and group_name (lindex 1) of the application group associated with the subsite that the current directory package is mounted under. The directory package does not need to be mounted directly under the subsite; it will find the closest instance of subsite than is an ancestor of the package.

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

Testcases:

No testcase defined.

Source code:

    
    set subsite_id [ad_conn subsite_id]
    
    db_1row g_i {
      select g.group_id, g.group_name
        from groups g, application_groups a
       where a.package_id = :subsite_id
         and a.group_id = g.group_id
    }

    return [list $group_id $group_name]

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

<fullquery name="dir_app_group_info.n_id">
    <querytext>
      
        select node_id from site_nodes
        where object_id = :package_id
    
      </querytext>
</fullquery>

<fullquery name="dir_app_group_info.g_i">
    <querytext>
      
      select g.group_id, g.group_name
        from groups g, application_groups a
       where a.package_id = :subsite_id
         and a.group_id = g.group_id
    
      </querytext>
</fullquery>

packages/directory/tcl/directory-procs.xql