acs_user::get_user_id_by_screen_name (public)

 acs_user::get_user_id_by_screen_name -screen_name screen_name

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

Returns the user_id from a screen_name, or empty string if no user found. Searches all users, including banned, deleted, unapproved, etc.

Switches:

-screen_name (required)

Testcases:

demote_promote_a_user

Source code:

    return [db_string select_user_id_by_screen_name {} -default {}]

Generic XQL file:

<fullquery name="acs_user::get_user_id_by_screen_name.select_user_id_by_screen_name">
    <querytext>

	select user_id from users where lower(screen_name) = lower(:screen_name)

      </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