| Filter in an LOV [message #611430] |
Wed, 02 April 2014 08:16  |
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  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
