lundi 10 mai 2021

Oracle Apex checkbox

I have a page within my app with a Checkbox option. The idea is basically to allow the user to select/unselect it if the change needs to be applied for every Sales Rep. Something like this: If checkbox is clicked = Change would be applied to all territories owned by the Rep If checkbox is not clicked = Change would only be applied to the selected territory

I can't seem to get the checkbox clicked option to work. I'm using an instr function to get a value out of it but it doesn't work:

select instr(':' ||:P11_CHECK_FOR_ALL|| ':', 'Request') into v_number_terr from dual;

if v_number_terr >0

(P11_CHECK_FOR_ALL is my checkbox Item / 'Request' is a word that's part of its label)

my checkbox pic

I'm trying to capture (in a process) whether the option is checked or not. Could someone give me a hand please?

Thanks!




Aucun commentaire:

Enregistrer un commentaire