ILya Cyclone wrote:Ilya,
kthomas, would you please read the first message carefully?
I need to have a dropdown list for the bind variable value in the af:query instead of default input text.
I can not just replace the inputText with a selectOneChoice because inputText is generated by af:query - there's no such component on design time!
ILya Cyclone wrote:I need filter a VO with an attribute which isn't in VO attributes (not in select). So I'm adding a bind variable and where clause like AND (id_attr = :p_id or :p_id iu null).
As the variable has required=true it appears in query panel and working fine.
But the UI control of the variable is inputText. What I need is choiceList with a view accessor-LOV.
And to my great surprise I can't find a way to change the UI of a bind variable or set a LOV ... Can you?
So basically I need to search a VO with some attribute which is not in sql select with a LOV and selectOneChoice component.I have created a sample app pointing to a table that I have with a table that holds a type and a description. The TYPE is the value that is stored in my MAIN table and is the bind variable P_PROBLEM_TYPE.
Also I wouldn't like to give up af:query and use ExecuteWithParams not to lose all those query features like advanced query etc.