notification::request::request_count (public)

 notification::request::request_count -type_id type_id \
    -object_id object_id

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

returns number of notification requests for this type and object

Switches:

-type_id

(required)

-object_id

(required)

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

Testcases:

No testcase defined.

Source code:

        return [db_string request_count {} -default 0]

Generic XQL file:

<fullquery name="notification::request::request_count.request_count">
    <querytext>
            select count(*)
            from notification_requests
            where type_id = :type_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