3 Replies Latest reply: Jul 9, 2012 3:05 PM by VC RSS

    Interactive Report select all rows

    joelanier
      I have a I/R report that a user can select columns, then update > 1 row a time with other page item values.
      I have SELECT ALL and CLEAR ALL page buttons.
      The report runs slow due to a very complicated sql statement.

      I am trying to select or clear column 1 without "submitting" the page, and rerunning the "slow" report again.
      Right now, the SELECT ALL:
      1) submits the page 2) sets Pxx_SELECT_ALL_ROWS = 'Y' 3) reruns the report with a decode that "checks" all rows.

      Is there a way to do this WITHOUT submitting the page?

      The checkbox is column 1 of each row using:
      HTMLDB_ITEM.CHECKBOX
      (1,R.RESEARCH_ID,
      decode(:Pxx_SELECT_ALL_ROWS,'Y','CHECKED',
      decode(instr(nvl(:Pxx_SELECTED_IDS,0),R.RESEARCH_ID),0,NULL,'CHECKED'))
      )
      AS select_flag,