notification::get_delivery_methods (public)

 notification::get_delivery_methods -type_id type_id

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

return a list of delivery methods associated with a given notification type (not all delivery methods are available to all notification types). The fields are: pretty_name, delivery_method_id

Switches:

-type_id (required)

Testcases:

No testcase defined.

Source code:

        return [db_list_of_lists select_delivery_methods {}]

Generic XQL file:

<fullquery name="notification::get_delivery_methods.select_delivery_methods">
    <querytext>
            select pretty_name,
                   notification_delivery_methods.delivery_method_id
            from notification_delivery_methods,
                 notification_types_del_methods
            where notification_delivery_methods.delivery_method_id = notification_types_del_methods.delivery_method_id
            and type_id = :type_id
            order by pretty_name
        </querytext>
</fullquery>

packages/notifications/tcl/notification-procs.xql

PostgreSQL XQL file:

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

Oracle XQL file:

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