42.2 HAS_PUSH_SUBSCRIPTION Function

This function returns whether a user has at least one device subscribed to push notifications.

Syntax

APEX_PWA.HAS_PUSH_SUBSCRIPTION (
    p_application_id IN NUMBER   DEFAULT [current application id],
    p_user_name      IN VARCHAR2 DEFAULT [current user] )
    RETURN BOOLEAN;

Parameters

Parameter	Description
p_application_id	ID of the application that has the push subscription.
p_user_name	Username of the user that has the push subscription.

Returns

Function returns boolean containing whether a user is subscribed to an application.

Example

The following example verifies whether user "SMITH" has a push subscription for application 100.

BEGIN
    apex_pwa.has_push_subscription (
        p_application_id => 100,
        p_user_name      => 'SMITH' );
END;