Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX 20.2 - Interactive report- Total record count

Srini.SFeb 22 2022

I have an interactive report that used to display total record count through pagination 'rows x-y of z'. However, in order to improve the performance of the report, I removed this pagination and use 'rows x to y'. However, I need to know the total number of records in the result. I would like to capture and display this information in a display only field. I am triggering an ajax callback process to run the query that runs in the IR and fetch the count and use it to display in the page item. However, this appears to be an inefficient, not a fool-proof method. The query is run twice un necessarily as well as I need to modify the ajax call back's query everytime I change the IR query. How to achieve my requirement more efficiently using DAs? I searched in the forums but can't see a solution that works for me.

Comments
Post Details
Added on Feb 22 2022
11 comments
2,887 views