Shay Shmeltzer's Oracle Development Tools Tips

  • January 7, 2011

Adding an LOV to a query parameter (executeWithParams)

Shay Shmeltzer
Director of Product Management - Oracle

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:

Join the discussion

Comments ( 9 )
  • Naga Thursday, January 20, 2011
    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

    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.
  • kojot Friday, January 21, 2011
    Which version of JDeveloper you used in this demo ? I'm unable to convert inputText to inputLOV in
  • shay.shmeltzer Friday, January 21, 2011
    This was recorded with - I checked and it does seem like in 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.
  • shay.shmeltzer Friday, January 21, 2011
    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.
  • bunnynew Friday, September 30, 2011

    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.


  • Shay Wednesday, October 5, 2011
  • Kishore Saturday, January 26, 2013


    I am unable to implement LOV on bind variable in ExecuteWithParams.

    I'm using jdeveloper 11g release 2.

    Plz solve my issue.

  • guest Saturday, January 26, 2013

    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:


    Also this might help you phrase your question:


  • guest Thursday, September 29, 2016


    What is the alternate method for getCriteria() of FacesCtrlLOVBinding.ListOfValuesModelImpl as that method is deprecated.

    Thanks in advance.

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.