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

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