1 Reply Latest reply: Dec 7, 2012 6:04 AM by Timo Hahn RSS

    Don't show the result table on a ADF Business component query

    962598
      Hi all,

      I work with adf business components and my query is :

      SELECT
      COLUMN1,
      COLUMN2,
      COLUMN3,
      COLUMN4     
      FROM
      MYTABLE
      WHERE
      (COLUMN1 = :PARAM1)


      I have a page "mypage.jsf" which I put one parameter "param1" variable defined on my query.
      When I click on button "ExecuteWithParams", I have the result table produced by my query.


      I modified my query by adding a second parameter like :

      SELECT
      COLUMN1,
      COLUMN2,
      COLUMN3,
      COLUMN4     
      FROM
      MYTABLE
      WHERE
      (COLUMN1 = :PARAM1) AND
      (COLUMN2 = :PARAM2)

      I add a second parameter "param2" to my page "mypage.jsp", No data is shown on
      my table ("No data to display") when I click on the button "ExecuteWithParams" (query return many records when I execute it with application module).

      I create another page "page2.jsf", I drag and drop the two parameter "param1", "param2", the button "ExecuteWithParams" and the ADF table to show the result
      of the query. When I click on my button, I have the good result on my table.


      Please, someone can help to know why table on "mypage.jsf" don't show the good results when I have two parameters "param1" and "param2"?


      Thanks in advance for your help,
      Carole