Hello,
I had such good luck on this forum with another question, I thought I'd pose the following:
I have a requirement for one of my LOV's (traditional, not pop-up) to show the full name of every active employee in the company - about 5,000. As much as I've begged and pleaded the client to find a way to reduce this list, the LOV must contain everybody (sigh). So, I've got the following query which returns the values for the LOV:
select full_name, person_id
from all_emp_table
where sysdate between effective_start_date and nvl(effective_end_date, sysdate)
and person_type_id = 01
order by 1
Is there a better way to do this? The rest of the page loads in just a second or two (when I set this LOV to never display) but with the LOV, it's taking closer to 15 seconds. I believe I tried with the pop-up LOV (that was a month or so ago), but I believe the problem was that it returns the display value rather than the id. Would it be better to build a little search form and populate a display only?
APEX Version 4.2.2
Thanks,
J.