group::get_members_not_cached (private)

 group::get_members_not_cached -group_id group_id -type type \
    [ -rel_type rel_type ] [ -member_state member_state ]

Defined in packages/acs-subsite/tcl/group-procs.tcl

Get party_ids of all members.

Switches:

-group_id

(required)

-type

(required)

Type of members - party, person, user

-rel_type

(optional)

-member_state

(optional)

when specified, return only members in this membership state

Author:

Timo Hentschel <timo@timohentschel.de>

Created:

2005-07-26

See Also:

• group::get_members
• group::flush_members_cache

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

Testcases:

No testcase defined.

Source code:

    return [db_list group_members {
        select distinct member_id
        from group_member_map m
        where group_id = :group_id
          and (:member_state is null or
               (select member_state from membership_rels
                 where rel_id = m.rel_id) = :member_state)
          and (:type is null or
               :type = 'party' or
               (select object_type from acs_objects
                 where object_id = m.member_id) = :type)
          and (:rel_type is null or
               rel_type = :rel_type)
    }]

XQL Not present:

Generic

PostgreSQL XQL file:

packages/acs-subsite/tcl/group-procs-postgresql.xql

Oracle XQL file:

packages/acs-subsite/tcl/group-procs-oracle.xql