25.1.9.2.4 Delivering Push Notification with Page Link

Send a push notification with an absolute page link generated from workflow activity data.

To prompt a user via push with a link to a data entry page, use a Send Push Notification activity. Since a workflow runs asynchronously in the background, the APP_USER system variable returns nobody. Therefore, this example workflow accepts a P_REQUESTED_USERNAME parameter, along with a P_SUBJECT parameter. The Additional Data query below on the Send Push Notification activity calls an ABSOLUTE_PAGE_URL function to generate the link to page 5, also passing the unique static ID of the wait activity user_provide_two_values. The query aliases the result to the LINK_TO_PAGE column name.

select 
    workflow_user_input.absolute_page_url(
        5,
        'user_provide_two_values'
    ) as link_to_page
  from dual

As shown below, the Send Push Notification activity's Title uses the &P_SUBJECT. substitution, the To field references the &P_REQUESTED_USERNAME. parameter, and the Link Target references #LINK_TO_PAGE# from the Additional Data query result.

Figure 25-64 Send Push Notification Uses Link from Additional Data Query

Description of "Figure 25-64 Send Push Notification Uses Link from Additional Data Query"