Oracle Apex - Email with custom link-CodePudding

I have a form where users can create tickets, these tickets are managed by a Team Leader who at the same time assigns each of the tickets to members on his/her Team. I know how to send out emails via Process or Dynamic Action but! I haven't been able to find a good tutorial on how to send a custom link. For example:

''A new ticket #12345 has been assigned to your queue, please follow this link to review: (link)''

I want that specific link to go directly into ticket #12345 in the App.

Does anyone know how to do it?

Thanks

CodePudding user response：

I assume that the page in question has a page-level item for the ticket you want to display. If so, you'd just need to generate a URL that includes that parameter using

SELECT APEX_PAGE.GET_URL (
        p_page   => 1,
        p_items  => 'P1_X,P1_Y',
        p_values => 'somevalue,othervalue' ) f_url_1,
     APEX_UTIL.PREPARE_URL('f?p=&APP_ID.:1:&APP_SESSION.::::P1_X,P1_Y:somevalue,othervalue')
 FROM DUAL;