Oracle Apex - Click Count

Card Puncher Data Processing

Oracle Apex - Click Count

About

Counts clicks to an external site.

how many user's click on a link specified.

See APEX_UTIL.COUNT_CLICK procedure

Management

Create

Log how many user's click on the http://yahoo.com link.

DECLARE
    l_url VARCHAR2(255);
    l_cat VARCHAR2(30);
    l_workspace_id VARCHAR2(30);
BEGIN
    l_url := 'http://yahoo.com';
    l_cat := 'yahoo';
    l_workspace_id := TO_CHAR(APEX_UTIL.FIND_SECURITY_GROUP_ID('MY_WORKSPACE'));
 
    HTP.P('<a href=APEX_UTIL.COUNT_CLICK?p_url=' || l_url || '&p_cat=' || l_cat || '&p_workspace=' || l_workspace_id || '>Click</a>');
END;

View

You can view it by using the APEX_WORKSPACE_CLICKS view and in the reports on this view available to workspace and site administrators.

Purge

Purging the External Click Count Log Administration > Manage Service > Developer Activity > Click Count Logs > Manage Click Count Log tab > Purge Click Log.





Discover More
Oracle Apex Report Columns Metadata
Oracle Apex - Metadata

The metadata of Oracle Apex are stored in a schema prefixed with APEX. From this schema, you can query the whole application definition: from page to columns APEX_APPLICATION_ALL_AUTH APEX_APPLICATION_AUTH...



Share this page:
Follow us:
Task Runner