APEX 19.1 running on RDBMS 12.2
On an Interactive Report, there is a column defined as type "Download BLOB." It has been working fine for some time. It allows users to download the contents of a BLOB in the ATTACHMENT table.
There is a column in the underlying table called, HAS_PII to say yes/no whether the attachment contains Personal Identifying Information. Only some users may see this information - and there is a an authorization scheme for whether the current user has the required permission. So if HAS_PII contains 'Y', the download link should not appear unless the user has this scheme.
So this is row-oriented - any user may download if HAS_PII on that row is 'N', but only certain users if it is 'Y'. Using the Security property or a server-side condition says whether the column is visible, not whether the link is active for that row.
I suspect that I need to change this to an Interactive Grid to give me more control. But is there another way?