notification::get_all_intervals (public)

 notification::get_all_intervals

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

return a list of all available intervals in a list of lists format, with the following fields: name, interval_id, n_seconds.

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

Testcases:

No testcase defined.

Source code:

        return [db_list_of_lists select_all_intervals {}]

Generic XQL file:

<fullquery name="notification::get_all_intervals.select_all_intervals">
    <querytext>
            select name,
                   interval_id,
                   n_seconds
            from notification_intervals
            where n_seconds>=0
            order by n_seconds
        </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