You can Create Post by clicking "Create post" & can reply or put comments for any existing post

74 posts

20 answers

13 comments

5,959 users

Contact me :
Email: dbahossain@gmail.com
Skype: apexexplorer
Phone:+880-1700514916

UpWork Contact Info:
Find Freelancers by: dbahossain
Or
Visit My direct Profile

How to find and display Apex user activity error log in the report

+2 votes
  • Create a new report using interactive report or classic and go to the query source section and type the below query :
 
select APPLICATION_ID
    ,apex_user 
    ,PAGE_ID                   
    ,PAGE_NAME  
    ,to_timestamp(localtimestamp - numtodsinterval(seconds_ago, 'SECOND')) as "VIEW_DATE"               
    ,ELAPSED_TIME            
    ,APEX_SESSION_ID           
    ,ERROR_MESSAGE             
    ,ERROR_ON_COMPONENT_TYPE           
    ,ERROR_ON_COMPONENT_NAME
    ,rows_queried                as "Rows Queried"
  from apex_workspace_activity_log
 where seconds_ago < 400000
 order by seconds_ago desc;
 
  • Run the application page you will see the details of error activity created by users.

Thanks

- Kamal

asked Sep 13, 2013 in Apex by admin (2,850 points)

Please log in or register to answer this question.

© 2013 apexexplorer.com. All rights reserved.
...