| Filter the LOV values [message #461167] |
Wed, 16 June 2010 20:13  |
coolguy01
Messages: 64
Registered: August 2006
|
Member |
|
|
Hi,
I have a field for which I need to get a list of values. So i have the following piece of code in the on-button-press button next to the field -
go_item('Myblock.Location'); do_key('List_values');
This would display the list of values for location, as long as the input focus is in a text item that has an attached LOV.
My problem is that i need to dynamically pass the region value to this LOV and the LOV should be filtered based for on that. For example if I have a region field selected as India I want the LOV for locations to be filtered to show only locations in India. So I want to dynamically pass the region value and filter the locations LOV.
|
|
|
|
| Re: Filter the LOV values [message #461192 is a reply to message #461167] |
Thu, 17 June 2010 00:51  |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Did you try to include "region" item into the WHERE clause of the Record Group's query (I guess LoV is based on it?). Something likeselect LoV columns
from some_table
where some_condition
and region = :region_block.region_item |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
