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
(defaults to "membership_rel") (optional)
-multiple
(boolean) (optional)

Partial Call Graph (max 5 caller/called nodes):
%3 test_acs_subsite_relation_procs acs_subsite_relation_procs (test acs-subsite) relation::get_object_two relation::get_object_two test_acs_subsite_relation_procs->relation::get_object_two db_list db_list (public) relation::get_object_two->db_list db_string db_string (public) relation::get_object_two->db_string relation::get_objects relation::get_objects (public) relation::get_objects->relation::get_object_two

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

[ hide source ] | [ make this the default ]
Show another procedure: