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):

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