relation::get_object_two (public)

 relation::get_object_two -object_id_one object_id_one \
    [ -rel_type rel_type ] [ -multiple ]

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

Return the object_id of object two if a relation of rel_type exists between the supplied object_id_one and it.

Switches:

-object_id_one (required)

-rel_type (optional, defaults to "membership_rel")

-multiple (optional, boolean)

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

Testcases:

acs_subsite_relation_procs

Source code:

    if {$multiple_p} {
        return [db_list select_object_two {}]
    } else {
        return [db_string select_object_two {} -default {}]
    }

Generic XQL file:

<fullquery name="relation::get_object_two.select_object_two">
    <querytext>

          select object_id_two 
          from   acs_rels 
          where  rel_type = :rel_type
          and    object_id_one = :object_id_one

      </querytext>
</fullquery>

packages/acs-subsite/tcl/relation-procs.xql

PostgreSQL XQL file:

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

Oracle XQL file:

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