Environment:
- Oracle APEX 21.2.3
- Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
I have a simple query based off a collection, that is in an Interactive Grid.
select coll.seq_id as seq_id
,coll.c001 as ssn
,wfs.toolkit.encrypt(coll.c001) as encrypted_ssn
,coll.c002 as diag_code
,coll.c003 as cancer_cert_status
,coll.d001 as diag_date
,coll.d002 as accep_date_latency
,coll.c004 as diag_desc
,'Update' as update_button_link
from apex_collections coll
where 1 = 1
and coll.collection_name = 'CANCER_HIST_COLLECTION'
and coll.c001 = :P25_SSN;
The final column is a “Link” type of column and the target is defined as:
End result looks like this:
When pressing the Update button goes to another page. This works fine.
An enhancement request came in from a user to “hide or disable” this Update “button” ONLY if a certain value is in the “Status” column.
I tried doing a dynamic action to enable/disable. I selected all appropriate options, but still I'm able to click the update button.
Even though the status is the value that should be the one to “disable”. FYI the “Status” column is an LoV. So for “In Progress” that actual value in the database is “P”. I created a DA on the IG region,
Set the TRUE/FALSE actions,
Yet this doesn't seem to work. I'm thinking because the LINK column is hard-coded/wired is the problem?
Suggestions?
Thanks,