Thursday, 8 October 2015

Creating report template in APEX 5.0

Bootstrap blog page with dynamic context

How to do this in your APEX applications?

Recently I started working with Bootstrap themes in APEX and this is a short info how to make some of the content on APEX page be retrieved by classic SQL report queries.

In our bootstrap theme there was a nicely looking page with details that we wanted to reuse, easiest way to achieve this is to create a new report template that will allow us to dynamically feed our page as classic SQL report region. 

If you have a look at below bootstrap blog page that we started from


We wanted to have something like this but with multiple instances that would be drawn from our table.  

To keep story short jump into Shared components select Templates -> Create template

Select Report type and give it a name that you like. Then jump back to it and edit this newly created template details.

For Row Template 1:
<article class="post">
<div class="post_header">
<h3 class="post_title"><a href="#LINK#" target="_blank"> #TITLE# </a></h3>
<div class="post_sub"><i class="fa-time"></i> Starting on: #STARTDATE# <br> Training duration: #DURATION# <br>Location: #ADDRESS# <br> </div>
<div class="post_sub" style="margin-top:10px;"><a href="#myModal" class="btn-success btn-sm " data-toggle="modal">Register now</a></div>
<div class="post_content">#HTML_CONTENT#</div>

For Before Rows in "Before first and after last row text" section set:
<div id="leftcol" class="col-sm-8 col-md-8">
and for After rows: 

Reason why we did this lies in original page source code. 
If you have a look of your original bootstrap theme code you will find details of how to actually do this is Bootstrap, in my example this is
In here you will notice tags starting with <article> </article>. This is what we needed to reproduce for our SQL generated reports. Similarly you have to do the same change depending on original template you started from.
Once you have done this all you have to do is create a region with a query that will contain all appropriate columns that you have used in your template. 
Under attributes Template select your newly created template and you are good to go. Hope you found this useful.
Thanks, SLino

No comments:

Post a Comment