person::get_person_info_not_cached (public)

 person::get_person_info_not_cached -person_id person_id

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

Extracts person information. Differently from person::get this proc won't return generic party information.

Switches:

-person_id (required)

See Also:

• person::get

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    db_0or1row get_person_info {
        select person_id,
               first_names,
               last_name,
               first_names || ' ' || last_name as name,
               bio
          from persons
         where person_id = :person_id
    } -column_array person

    return [array get person]

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