{"id":10301,"date":"2020-07-23T01:56:53","date_gmt":"2020-07-23T07:56:53","guid":{"rendered":"https:\/\/traust.com\/?p=10301"},"modified":"2021-06-23T17:22:30","modified_gmt":"2021-06-23T22:22:30","slug":"oracle-apex-dynamic-action-on-a-list-view-element","status":"publish","type":"post","link":"https:\/\/traust.com\/blog\/oracle-apex-dynamic-action-on-a-list-view-element\/","title":{"rendered":"Oracle APEX Dynamic Action on a List View Element"},"content":{"rendered":"

The List Views in Oracle APEX look fantastic, but it would be nice to extend the functionality of them by adding a Dynamic Action when an item is clicked.\u00a0 To setup the situation, imagine a hotel manager that wants an app for room cleaners that displays a list of rooms marked with a status of “Being Cleaned.”<\/p>\n

\"\"<\/p>\n

After a room is cleaned and ready for use, the hotel manager would like the room cleaners to be able to click on a room in the list, get prompted with a confirm message, and then have the room they clicked on have its status updated to “Available.”<\/p>\n

\"\"<\/p>\n

Intuitively, I thought this would require doing something similar to what Jackie McIlroy describes<\/a>.<\/p>\n

Following Jackie’s template, I did the following with a List View Region (instead of the Interactive Report Region example in her blog)<\/p>\n

    \n
  1. \n
      \n
    1. Created a hidden item called P1_ROOM_ID<\/li>\n
    2. Created a List View Region<\/li>\n
    3. For the Attributes on the List View Region, I changed the Settings by adding a span class to List Attributes and a data-id value to List Entry Attributes.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n