party::get_by_email_not_cached (public)

 party::get_by_email_not_cached -email email

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

Return the party_id of the party with the given email. Uses a lowercase comparison as we don't allow for parties to have emails that only differ in case. Returns empty string if no party found.

Switches:
-email (required)
Returns:
party_id

Partial Call Graph (max 5 caller/called nodes):
%3 party::get_by_email party::get_by_email (public) party::get_by_email_not_cached party::get_by_email_not_cached party::get_by_email->party::get_by_email_not_cached db_list db_list (public) party::get_by_email_not_cached->db_list

Testcases:
No testcase defined.
Source code:
    #    return [db_string select_party_id {} -default ""]

    # The following query is identical in the result as the one above
    # It just takes into account that some applications (like contacts) make email not unique
    # Instead of overwriting this procedure in those packages, I changed it here, as the functionality
    # is unchanged.
    return [lindex [db_list select_party_id {}] 0]
Generic XQL file:
<fullquery name="party::get_by_email_not_cached.select_party_id">
    <querytext>

        select party_id
        from   parties
        where  lower(email) = lower(:email)

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