This content has been marked as final. Show 2 replies
Instead of using "Display extra values" make sure the extra value is part of the LOV by adding an or to the select.
Where pXX_lov is the name of the item the lov belongs to.
select emp.last_name , emp.employee_id from oehr_employees emp where emp.department_id = 10 or emp.employee_id = :pXX_lov