I'm developing in Jdeveloper 184.108.40.206.0.
What im going to do is, i need to change lov depends on the value selected by the another lov.
Both LOV's are created by different viewobjects.But the second lov change when return more than one record by the query.
If there's no data,it's not change.
I need to set blank LOV at this time.
How can i do this?
Edited by: Charith Kulawardana on Nov 13, 2012 1:41 AM
If you are filtering through a ViewCriteria, you have to uncheck the option "Ignore Nulls Values".
These blogs explain how to filter using View Criteria:
And this blog explains how to filter using just a bind variable (without ViewCriteria):
I'm not using view criteria.
I have 2 view objects.
There are 2 columns like 'CountryCode' and 'AgentType' in 1st view object.
There are 3 columns like 'CountryCode' , 'AgentType' and 'AgentName' in 2nd view object.
What i need to do is, I need 'to create LOV(display 'AgentName') where veiw2.CountryCode=veiw1.CountryCode AND veiw2.AgentType= veiw1.AgentType.
I applied above condition through view link and lov is getting values properly.
Suppose there's 'CountryCode' : USA and 'AgentType' : WEBAGENT .....then LOV getting Values 'A','B','C'.
After that i changed the 'CountryCode' and 'AgentType' which return no_data.
Then Lov should be blank,but in this case lov remains the previous values ( 'A','B','C').
This case happening only in 'Modify mode' and in 'ADD mode' it is working fine.
Any suggestions pls!
Edited by: Charith Kulawardana on Nov 14, 2012 3:26 AM
Edited by: Charith Kulawardana on Nov 14, 2012 3:27 AM