Hi All,
In Apex 23.2
I have a page item that holds the TO: email addresses in order to use them to call Apex_mail.
I set the new combobox to be Multiple Values and the comma as the separator using a Dynamic LOV that show names and emails from a table. Also, I later want to group emails by a group field and creating and merging different tables that holds emails. Not doing that right now.
This is the query am using in the LOV:
select cliente_id,
asegurado,
email,
'ASEGURADO' as grupo
from risk_clientes
where organizacion_id = :APP_GET_ORGANIZACION_ID
order by 1
Right now is working fine. Showing Asegurado and email and group by GRUPO.
The problem is that since am using the page item as the TO addresses to send emails I would need the combobox to return the EMAIL and not the CLIENTE_ID But when I change the Return Value to EMAIL I get this error as soon as I place the cursor in the page item .
Is there a way to set the query or Combobox to return the EMAIL into the page item and not the cliente_id?
Thanks for the help!
Javier