notification::type::get_type_id_not_cached (private)

 notification::type::get_type_id_not_cached short_name

Defined in packages/notifications/tcl/notification-type-procs.tcl

return the notification type ID given a short name. Short names are unique but not primary keys.

Parameters:

short_name

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

Testcases:

No testcase defined.

Source code:

        return [db_string select_type_id {} -default {}]

Generic XQL file:

<fullquery name="notification::type::get_type_id_not_cached.select_type_id">
    <querytext>
            select type_id
            from notification_types
            where short_name = :short_name
        </querytext>
</fullquery>

packages/notifications/tcl/notification-type-procs.xql

PostgreSQL XQL file:

packages/notifications/tcl/notification-type-procs-postgresql.xql

Oracle XQL file:

packages/notifications/tcl/notification-type-procs-oracle.xql