Hi,
Under Oracle APEX 24.2.10, I have P.39 of application 108 two interactive grids “Bénévoles” and “Référents”. The user select in a select list a user and the select list return the ID of the user contained in a table “AD_BENEVOLE”.
This SQL command returns all the ID of the users contained in the rwo interactive grids :
select a.id_benevole, b.ID_referent
from ad_crise_benevole a, ad_crise_referent b
where a.id_crise = :P39_ID and b.ID_CRISE=:P39_ID
I have on the same page a form “Envoi de SMS”. I would like to show dynamically this region (probably using Javascript in a DA) if the result of the SQL above command contains the ID of ID_BENEVOLE or ID_REFERENT of the two interactive grids. I would like this form “Envoi de SMS” to be hidden if the result of the SQL request does not return anything ("Data not found") if the two interactive grids does not contain ID_BENEVOLE or ID_REFERENT. I would like also that this region “Envoi de SMS” to be refreshed if lines are added or deleted from the two interactive grids on “Event : Save (Interactive Grid)”.
Best regards.