Oracle Apex 20.1. Report with 'Cards' template, how to redirect to another page on click a card?
Solution 1:
CARD_LINK should be a link to another page. Create it any way you want, but - I prefer APEX_URL.GET_URL
select <CARD_... columns here>,
--
apex_page.get_url (p_page => 2, --> go to page 2
p_items => 'P2_ID', --> to P2_ITEM ...
p_values => a.id) card_link --> ... pass a.id column value
from some_table a
where ...
At the end, it'll look like e.g.
f?p=:2:::::P2_ID:1056