Shay Shmeltzer's Oracle Development Tools Tips

  • December 28, 2010

Combining Multiple Queries and Parameters into One Operation

Shay Shmeltzer
Director of Product Management - Oracle

This question came up twice this week and while the solution is explained in a couple of previous blog entries I did, I thought that showing off the complete solution in a single video would be nice.

The scenario is that you have two VOs with queries that are based on a parameter, I showed in the past how to create a parameter form that executes the query - and you can do this for both.

But what if you actually need just one value to drive both queries? How do you combine two parameter forms and two buttons into one?

This is what this video shows you. The steps are:

Creating two parameter forms

Setting the value of a parameter in the binding tab

Creating a backing bean to execute the code for one button

Adding the code to execute another operation

Remarking the parts that can be dropped from the screen

Check it out here:

Join the discussion

Comments ( 7 )
  • Barbara Gelabert Wednesday, December 29, 2010
    Thanks for this great post, Shay.
  • guest Friday, May 4, 2012

    It's really awesome thank you , I just want to know one more thing , what we should do when we have more than 1 query on the same table , in my case I want to apply 4 different query on the same table .

    please advise

  • Shay Friday, May 4, 2012

    guest, you can have a VO service method that dynamically adds one of 4 view criterias to your VO definition. Or maybe uses the setWhereClause method of the VO.

    Something like:




  • guest Friday, May 18, 2012

    Thanks Shay its really solved my problems

  • guest Monday, March 10, 2014

    thanks for this post Shay,

    one question :

    is it possible to do same thing without parameter form?

    i want to do it for four(4) queries, with same parameter , and that parameter can be in combobox...

  • Mahesh Wednesday, June 11, 2014


    Your blogs are very helpful.

    I need some interview questions, Please provide if you have



  • bali Thursday, September 15, 2016

    Hi, i am working on adf query with Table(sort,filter enable). Now, i want reset button to clear query field, filter and resulted table.

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