acs_user::get_portrait_id_not_cached (private)

 acs_user::get_portrait_id_not_cached -user_id user_id

Defined in packages/acs-tcl/tcl/community-core-procs.tcl

Return the image_id of the portrait of a user, if it does not exist, return 0

Switches:
-user_id (required)
user_id of the user for whom we need the portrait

Partial Call Graph (max 5 caller/called nodes):
%3 acs_user::get_portrait_id acs_user::get_portrait_id (public) acs_user::get_portrait_id_not_cached acs_user::get_portrait_id_not_cached acs_user::get_portrait_id->acs_user::get_portrait_id_not_cached db_string db_string (public) acs_user::get_portrait_id_not_cached->db_string

Testcases:
No testcase defined.
Source code:
    return [db_string get_portrait {
        select c.item_id
        from acs_rels a, cr_items c
        where a.object_id_two = c.item_id
        and a.object_id_one = :user_id
        and a.rel_type = 'user_portrait_rel'
    } -default 0]
Generic XQL file:
packages/acs-tcl/tcl/community-core-procs.xql

PostgreSQL XQL file:
packages/acs-tcl/tcl/community-core-procs-postgresql.xql

Oracle XQL file:
packages/acs-tcl/tcl/community-core-procs-oracle.xql

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