29.7 GET_LAST_VIEWED_REPORT_ID Function

This function returns the last viewed base report ID of the specified page and region.

Syntax

APEX_IG.GET_LAST_VIEWED_REPORT_ID (
    p_page_id   IN NUMBER,
    p_region_id IN NUMBER );

Parameters

Table 29-7 GET_LAST_VIEWED_REPORT_ID Parameters

Parameter	Description
p_page_id	Page of the current Oracle APEX application that contains an interactive grid.
p_region_id	The interactive grid region ID.

Example

The following example shows how to use the GET_LAST_VIEWED_REPORT_ID function to retrieve the last viewed report ID in page 1, region 3335704029884222 of the current application.

DECLARE
    l_report_id number;
BEGIN     
    l_report_id := APEX_IG.GET_LAST_VIEWED_REPORT_ID (
        p_page_id   => 1,
        p_region_id => 3335704029884222);
END;