There is a great discussion here on the various badge options in APEX
Apex 5.1 Badge list
Among other things, it refers to the Badge plugin from the sample application, and when defining a link target you can "Incorporate the PK_ID"
I elected to try this plugin since the badge list report template does not support links from each badge.
The badge list template does support links, but the plugin has a cleaner display.
However, when I tried to define each badge to link to a page, parameterised by the relevant label/code.
I get this
f?p=102:57:203713127163::NO:RP:IREQ_STATUS_CODE:&cs=18B8E69DFDE7E874C5E0E51CD1AC42B28#STATUS_CODE#
Not this
f?p=102:57:203713127163::NO:RP:IREQ_STATUS_CODE:ABC&cs=18B8E69DFDE7E874C5E0E51CD1AC42B28
I checked the plugin code and it's replacing substitution strings
l_url := apex_util.prepare_url (
apex_plugin_util.replace_substitutions (
p_value => c_link_target,
p_escape => false ));
But I suspect it's targeting &APP_ITEM. references, not information coming from the SQL column.
Is there something I can do in the plugin? Some other API that needs invoking?
Scott
APEX 5.0.1