I have a report table view with multiple line entries on it. I need to display a link to another page for user action only if a value in the row matches a role attribute of the user so they may take action on the item. Others viewing or updating the document should not be able to execute the link.
The pseudo logic would go something like this:
If user_role = role_this_line_item then
display approval_link
else
hide approval_link
end if
I know how to write the pl/sql to return the correct true/false condition display, but I am having trouble knowing how to reference the value on the display row. I have tried :role_this_line_item, role_this_line_item, #role_this_line_item# and none of them return any value other than false. How do I reference a attribute on the current row to make the correct hide/display decision?
Al