Video: Part 2 – APEX Classic Report Named Column Templates

Posted on Posted in APEX, Classic Reports, Video

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

About

Hi, I'm Jorge Rimblas. Father, husband, photographer, Oraclenerd, Oracle APEX expert, Oracle ACE, coffee lover, car guy, gadget addict, etc... I'm an APEX Tech Lead DRW. I have worked with Oracle since 1995 and done eBusiness Suite implementations and customizations. Nowadays I specialize almost exclusively in Oracle APEX.

6 Comments on “Video: Part 2 – APEX Classic Report Named Column Templates”

  1. 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!

    Reply

    • 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!

      Reply

  2. 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

    Reply

  3. Hi Jorge,

    It’s an awesome example of template creation. I am beginner in apex development. I want to create my own template which will act as parent child data table along with multiple add rows options in a hierarchy. Can you please suggest me how can I do this using custom template? Any short view example would helps a lot.

    Thanks in advance

    Reply

I love comments, write me a line