Home » Developer & Programmer » Forms » Filter in an LOV (Forms 10g)
Filter in an LOV [message #611430] Wed, 02 April 2014 08:16 Go to next message
Rajat Thakur
Messages: 3
Registered: December 2004
Junior Member
Guys,

We all know that there is a "Find" item in the forms List of Values.

Users want this to be pre-populated based on another item in the form for example if the value of the item is TEST, the Find box should have %TEST% in it obviously the List will start of filtered, subsequently the users should be able to clear the Find box and all the rows should be returned. I did it many years ago but forgot how I did it. Any ideas how this can be implemented?

Rgds
Re: Filter in an LOV [message #611488 is a reply to message #611430] Thu, 03 April 2014 01:16 Go to previous message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here's one option. LoV's source query is written in its Record Group. Modify it so that it looks like this:
select dname, deptno
from dept
where dname like '%'|| :block.department_name ||'%'    --> this!
order by dname

Once you open list of values, it will display departments that contain value written in :BLOCK.DEPARTMENT_NAME item.
Previous Topic: Export Data From Excel and save on an existing excel file
Next Topic: FRM-92052: fatal error: cannot connect to the server at URL %s
Goto Forum:
  


Current Time: Tue Mar 19 03:10:54 CDT 2024