Hi,
Under Oracle APEX 24.2.9, I have a form with an interactive grid. The source of the IG is the table AD_TACHE. The IG looks like this :
I have created a virtual column named “Courriel bénévole”and you can see it is blank.
The value of this column is calculated in a select LOV of the virtual column:
select a.ID d, a.ID R FROM AD_BENEVOLE a, AD_TACHE B WHERE BENEVOLE = a.ID AND a.id = b.benevole
But It does not display anything in the virtual column Courrier bénévole. I want to put into the select the ID of the displayed ID in the interactive grid, here 1873. How to refer to that value in my select ?
Best regards.