Databases Reference
In-Depth Information
Note
Once an Interactive Report is rendered to the page, any changes made to the filters, sorting, column
selection, etc. are done via AJAX calls. Therefore these changes are
not
tracked by debug mode unless the entire
page is refreshed. To refresh an entire page, you can either toggle Debug mode off and then back on, or you can
force a page refresh using your browser.
Consider the two debug snippets shown in Figures 6-17 and 6-18. Both snippets are from the same
interactive report.
Figure 6-17.
Debug data for the default version of an interactive report
Figure 6-17 shows the detail debug data for an Interactive Report region
prior
to a user having made
any changes to the report. You can tell the following from the figure:
•
Line 35 indicates the start of the region.
•
Line 38 lists the columns that will be displayed.
•
Line 40 shows the base SQL statement.
•
Line 41 shows the value of the APXWS_MAX_ROW_CNT bind variable, as it will be
used in the SQL statement.
