notification::type::interval_enable (public)

 notification::type::interval_enable -type_id type_id \
    -interval_id interval_id

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

Intervals must be enabled on a per notification type basis. For example, weekly notifications may not be enabled for full forum posts, as that might be too much email (system choice) This enables a given interval for a given notification type.

Switches:

-type_id (required)

-interval_id (required)

Testcases:

No testcase defined.

Source code:

        # Perform the insert if necessary
        db_dml insert_interval_map {}

Generic XQL file:

<fullquery name="notification::type::interval_enable.insert_interval_map">
    <querytext>
            insert
            into notification_types_intervals
            (type_id, interval_id)
            select :type_id,
                   :interval_id
            from dual
            where not exists (select 1
                              from notification_types_intervals
                              where type_id = :type_id
                              and interval_id = :interval_id)
        </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