acs_user::get_by_username_not_cached (private)

 acs_user::get_by_username_not_cached -authority_id authority_id \
    -username username

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

Returns user_id from authority and username. Returns the empty string if no user found.

Switches:
-authority_id
(required)
The authority. Defaults to local authority.
-username
(required)
The username of the user you're trying to find.
Returns:
user_id of the user, or the empty string if no user found.

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

Testcases:
No testcase defined.
Source code:
    return [db_string user_id_from_username {} -default {}]
Generic XQL file:
<fullquery name="acs_user::get_by_username_not_cached.user_id_from_username">
    <querytext>

            select user_id
            from   users
            where  lower(username) = lower(:username)
            and    authority_id =:authority_id

      </querytext>
</fullquery>
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: