Adding an LOV to a query parameter (executeWithParams)

I showed in the past how you can use the executeWithParams operation to build your own query page to filter a view object to show specific rows.
I also showed how you can make the parameter fields display as drop down lists of values (selectOneChoice).

However this week someone asked me if you can have those parameter fields use the advanced LOV component.
Well if you just try and drag the parameter over, you'll see that the LOV option is not there as a drop option.
But with a little bit of hacking around you can achieve this. (without actual Java coding).
Here is a quick demo:

Comments:

hi shay, i have tried the same example but can we use the same VO instead of 2 different VO's in this example. i have tried but i am getting the exception like Server Exception during PPR, #1 java.lang.NullPointerException at oracle.adfinternal.view.faces.model.binding.FacesCtrlLOVBinding.getSearchBinding(FacesCtrlLOVBinding.java:188) at oracle.adfinternal.view.faces.model.binding.FacesCtrlLOVBinding$ListOfValuesModelImpl.getSearchRegion(FacesCtrlLOVBinding.java:1434) at oracle.adfinternal.view.faces.model.binding.FacesCtrlLOVBinding$ListOfValuesModelImpl.getQueryModel(FacesCtrlLOVBinding.java:1070) when i try to click on lov button and popup is not opening. Please advise on this.

Posted by Naga on January 20, 2011 at 08:08 AM PST #

Which version of JDeveloper you used in this demo ? I'm unable to convert inputText to inputLOV in 11.1.1.1.4.

Posted by kojot on January 20, 2011 at 10:50 PM PST #

This was recorded with 11.1.1.3 - I checked and it does seem like in 11.1.1.4 you can't do the conversion. Instead you'll just need to add the inputLOV to the page and set the values for its properties manually.

Posted by shay.shmeltzer on January 21, 2011 at 01:35 AM PST #

I don't think the same view will work - since the view that uses the query will not have all the records in it when you create the LOV.

Posted by shay.shmeltzer on January 21, 2011 at 07:57 AM PST #

Hi Shay,

How to show lov item label instead of id , after selecting & closing LOV dialog. but the af:table should execute its query based on id.
Users are not interested to see id of item.

Regards.

Posted by bunnynew on September 29, 2011 at 10:36 PM PDT #

Bunnynew - check out this entry: http://blogs.oracle.com/shay/entry/whenvalidateitem_trigger_in_ad

Posted by Shay on October 05, 2011 at 03:55 AM PDT #

Hi,

I am unable to implement LOV on bind variable in ExecuteWithParams.
I'm using jdeveloper 11g release 2.
Plz solve my issue.

Posted by Kishore on January 26, 2013 at 10:08 AM PST #

Kishore, you haven't provided any information that will help people solve your issue. May I suggest that you use the OTN Forum to ask your question:
http://forums.oracle.com/forums/forum.jspa?forumID=83
Also this might help you phrase your question:
https://blogs.oracle.com/shay/entry/10_commandments_for_the_otn_fo

Posted by guest on January 26, 2013 at 10:27 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

me
I'm a Director of Product Management for the Oracle Java Development Tools.
Follow me:
Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today