Hi,
In Apex 23.2
What am trying to accomplish is to have a combobox page item where I can select multiple emails and also enter emails manually. The LOV return just the email separate with comma. I want the LOV group by Tipo and the name and email in differents lines.
I have it but am getting this error when entering information into the combobox.
Here is the query am using:
select email as email_id,
asegurado,
email,
'ASEGURADOS' as tipo
from risk_clientes
where organizacion_id = :APP_GET_ORGANIZACION_ID
order by 1
And how I have it set:
I know is hard to debug from images but just in case somebody see something I dont.
Thanks for the help!
Javier