Filter in an LOV [message #611430] |
Wed, 02 April 2014 08:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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.
|
|
|