notification::request::get_request_id (public)

 notification::request::get_request_id -type_id type_id \
    -object_id object_id -user_id user_id

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

Checks if a particular notification request exists, and if so return the request ID. Note that the primary key on notification requests is notification_type, object, user. Interval and delivery method are specific parameters, but do not impact the uniqueness: a user can choose only one interval and delivery method for a given notification type and object.

Switches:

-type_id (required)

-object_id (required)

-user_id (required)

Testcases:

No testcase defined.

Source code:

        return [db_string select_request_id {} -default {}]

Generic XQL file:

<fullquery name="notification::request::get_request_id.select_request_id">
    <querytext>
            select request_id
            from notification_requests
            where type_id = :type_id
            and user_id = :user_id
            and object_id = :object_id
        </querytext>
</fullquery>

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

PostgreSQL XQL file:

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

Oracle XQL file:

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