Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX 5: interactive reports, report attribute conditional link display

alexoraApr 25 2016 — edited Apr 26 2016


I've seen many replies on how to conditionally display column links for Interactive reports.

But what if I have IR Report link attribute ( which does not apply to any specific column but this is an Attribute of Report ) with the following link

Link column:    onmouseover="toolTip_enable(event,this,'Edit')"

So I would like to display this "Edit" link ONLY for some values from specific column.

I've tried to add Condition Type Boolean PL/SQL to my Interactive report attributes but the problem is that I do not know how to obtain the values for those specific columns of each row I need to check the value for so when I add debug statements to my PL/SQL condition I see it displays NULL value

BEGIN

apex_debug.enable(7);

apex_debug.log_message('APEX DEBUG OWNER....'||:P2_ID);

apex_debug.log_message('APEX DEBUG OWNER....'||:P2_OWNER);

apex_debug.disable;

return true;

END;

I've read different suggestions about this but what would be the best and easiest solution to populate P2_ID and P2_OWNER for each row of my Interactive report so I could take advantage of this Condition display for the report link which does not apply to any specific  column ?

Or perhaps there is a better way ?

Thank you,

Alex

This post has been answered by PMON on Apr 25 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 24 2016
Added on Apr 25 2016
6 comments
2,063 views