Hi,
Under Oracle APEX 24.2.10, I try to hide/show dynamically a region “Envoi de SMS” when an item on a form “AD_CRISE”, P39_REFERENT type LOV is modified on this region. This LOV returns the column CREE_PAR of the table “AD_CRISE_SMS”. This is the select of the LOV :
select b.ID "R", B.NOM || ' ' || b.PRÉNOM || ' - ' || ID_ASSOCONNECT "D" from APEX_APPL_ACL_USERS a, AD_BENEVOLE b WHERE APPLICATION_ID = :APP_ID AND ROLE_NAMES LIKE '%Référent%'
and a.USER_NAME = b.USERNAME order by b.Nom
If the ID of the user in the table “AD_BENEVOLE” is not the same as the one selected in the element P39_REFERENT, then this region should be hidden. I have tried to implement a dynamic action following this post, but It does not work for me.
https://forums.oracle.com/ords/apexds/post/dynamic-action-show-hide-region-based-on-lov-which-returns-8870
I have tried this DA to hide the region with a JavaScript expression with this True condition:
$(this.triggeringElement).children("option:selected").html()
And created the False action Show region “Envoi de SMS”.
Should I create an element ID_BENEVOLE on the form “Crise” ?
Any help greatly appreciated.
Best regards.