Video: Part 2 – APEX Classic Report Named Column Templates

I’m happy to bring you installment Number 2 of this video series. If you missed the first one, you can find it here Part 1.

We’ll call this the “Dynamic Action” edition because that’s what most of the video deals with.

In this 39 minute video you’ll find:

  • 0:00 to 5:49 — Fix a bug from part 1.
  • 5:50 to 30:49 — Add ability to toggle the todo checkboxes by just clicking them.
  • 30:50 to 39:00 — Add a “Trash” icon to delete a todo entry.

Part 2: APEX Classic Report Named Column Templates from Jorge Rimblas on Vimeo.

At around 13:23 some sort of noise affected the recording. Not sure why. Unfortunately, it did affect the quality of the rest of the recording. I’ll have to look into that and resolve it before recording 003.

Next: Part 3

Hi, I'm Jorge Rimblas. Father, husband, photographer, Oraclenerd, Oracle APEX expert, Oracle ACE, coffee lover, car guy, gadget addict, etc... I'm a Senior APEX Consultant with Insum Solutions, a consulting firm specialized in Oracle databases and the APEX development tool. I have worked with Oracle since 1995 and done eBusiness Suite implementations and customizations. Nowadays I specialize almost exclusively in Oracle APEX.

Posted in APEX, Classic Reports, Video
4 comments on “Video: Part 2 – APEX Classic Report Named Column Templates
  1. Martin Vallejo says:

    Hello Jorge, Great post!

    After your first entry I made something similar, but I added and removed the class to do the effect in the checkbox. I don’t know if it the best approach.

    $(this.triggeringElement).removeClass(‘fa-check-square-o’);
    $(this.triggeringElement).addClass(‘fa-square-o’);

    Thanks for the video!

    • It’s not a bad approach at all. The benefit of removing and adding the class (before the AJAX call) is that the user gets immediate feedback. But then let me ask, do you Refresh the report? If you do, you’re undoing what you just did. Not a bad thing, just something to keep in mind for more complex situations.
      I would probably recommend one more dataset element to keep track of the checkbox status, only so that you can recover if something fails. And then, to recover better, I would use an apex.server.process call instead of the PL/SQL action because then you can control what to do in case of success and failure.

      Thank you for following along!

  2. Jeff Stephenson says:

    First of all, great post. I had watched this awhile back, but I just went back to it because of an issue that I was facing. I added the ability to add a row to a middle of a tabular form by clicking a plus button on that row and it worked great, but the page kept moving back to the top after I clicked the icon. Your explanation on the url link of # was great. I have been in the practice of using #, but from now on #0. Thanks for all of the great information.

    Thanks,
    Jeff

2 Pings/Trackbacks for "Video: Part 2 – APEX Classic Report Named Column Templates"
  1. […] the last 16 min are for the building of the template example. When you’re done with this one, watch the follow-up video where I extend the functionality with some useful Dynamic […]

  2. […] see me working on the list created in the previous episodes (Part 1 and Part 2) and transform it to something a lot more […]

I love comments, write me a line