| Limit list of values [message #472150] |
Thu, 19 August 2010 01:45  |
coolguy01
Messages: 64
Registered: August 2006
|
Member |
|
|
I have a field in a form based on which value i have to filter a list of values. So in the query for the record set i have filtered the query using the where condition like where column_name = :block.item. So that would filter the LOV based on that value in that field. My problem is that that there can be multiple rows for that block and the same item used to filter can have multiple values because of multiple rows. Now how do i pass these different values to the record set and filter the LOV.
For ex if the value is for city fields i could have 2 different rows with one value for city being NY and second row being CA. NOw i have to dynamically pass these city values to a list of value and filter the LOV.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
