APEX-AT-WORK by Tobias Arnhold

Browsing "Older Posts"

Getting the amount of rows from report with jQuery

Von Tobias Arnhold → 5.16.2013

I had the task to show the amount of displayed rows from a standard report on another position of the page. As "Pagination Scheme" in the "Report Attributes" I used: "Row Ranges X to Y from Z"

To get this Z value I needed to check the HTML code:

<td nowrap="nowrap" class="pagination">
   <span class="fielddata">Zeile(n) 1 - 15 von 329</span>
</td>

Inside class "fielddata" was my value Z. To get the value I needed this little piece of jQuery:

var v_txt = $('.fielddata').html();
var v_num = v_txt.split(' ');
var v_return= v_num[v_num.length - 1];

APEX examples

Expand APEX tree after page load

Von Tobias Arnhold → 5.03.2013

This little snippet of code will expand the APEX tree:

$("input:[value='Expand All']").click();

This solutions finds the HTML objects by the displayed value. Use it in a "Dynamic Action > Page Load > Execute Javascript" process.

In case you use multi language applications then this solution will fit better:
http://apextips.blogspot.de/2011/03/expand-and-collapse-all-tree-nodes.html