Tuesday 7 March 2017

Getting selected Rows in Oracle APEX Interactive Grid

I tried doing lot of things!! A lot, indeed. Very little help  out there on Stack Overflow. So I'm writing this to help developers who are starting with Oracle APEX.

Use Case : Get selected row(s) from a region such as Interactive Grid/Interactive Report. APEX does not provide a declarative way to perform this operation in Javascript. I tried apex.item(), $v() etc. Nothing seemed to work out.

These are the steps I followed to get the selected selected row from the interactive grid in Oracle APEX.

1. Have a ROW Selector column in the Interactive Grid





2. Create a Dynamic Action in the Grid, with the Event being 'Selection Change [Interactive Grid]'. Now this event is fired each time a selection is changed in the grid. I've disabled multi-select in my grid, but this approach works for multiple selections too.



3. In true action, select 'Execute Javascript Code' and type in the following code


if(this.data != null){
    if(this.data.selectedRecords[0]!= null){
        selectedRecord = this.data.selectedRecords[0][0];
        console.log(selectedRecord);
    }

}




 How did I figure this out? Let's just simple do a console.log(this) on the 'Selection Change' Event.

Here's the screenshot of what is logged on the console.



this.data has selectedRecords, there you go!!! Had some trouble figuring that out! Phew!

Tags : Oracle APEX 5, Oracle APEX5  Interactive Grid selected row javascript, Oracle APEX5 Interactive Grid javascript listener, Oracle APEX5 Region Row Selection, APEX5 region javascript, Oracle APEX5 blog, Oracle APEX5 javascript Interactive grid
 
Posted by at
Labels: , , , , ,

11 comments:

  1. Persian Apex1 October 2017 at 15:22

    Nice .

    ReplyDelete
  2. Unknown15 November 2017 at 22:36

    Nice try. Helps me a lot.

    ReplyDelete
  3. Ganesh Nimkar29 May 2018 at 23:05

    nice its work...great job..!

    ReplyDelete
  4. Unknown7 December 2018 at 11:54

    Thank you for your post, it helped me.

    ReplyDelete
  5. Muddasar Amin23 December 2018 at 05:17

    While selecting multiple rows by rowSelector, and editing some other fields on the same time, rowSelector deselects all the rows, and then doesn't allow to select even a single row. Why this behavior? any suggestions please to fix it?

    Thanks

    ReplyDelete
  6. Karkuvelraja Thangamariappan19 February 2019 at 22:51

    This comment has been removed by the author.

    ReplyDelete
  7. Dipling16 November 2019 at 02:50

    Hello.

    How can you get return value of "select list" or "shuttle" type column?

    Thanks.

    BR

    ReplyDelete
  8. Dipling16 November 2019 at 03:18

    Solution:
    return value: this.data.selectedRecords[0][0].v
    display value: this.data.selectedRecords[0][0].d

    BR

    ReplyDelete
  9. welims11 May 2020 at 20:18

    Thanks !

    ReplyDelete
  10. Unknown18 August 2020 at 23:12

    Can i get data while row initialization?!

    ReplyDelete
  11. Andrea Elizabeth26 October 2020 at 09:36

    Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle Fusion HCM . Actually, I was looking for the same information on internet for
    Oracle Fusion HCM Interview Questions and Answers and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject.

    ReplyDelete

Subscribe to: Post Comments (Atom)