Hi! I want to display column "Last User Login" to IR(on that report I use database table) and display date and time for this column. Is there an apex table to track user logins? If exist, could I display this column on existing IR? Thanks in advance!
Vinish Kapoor
There is no such existing table from which you can get the login details. But you can create one and log the details as follows: Create a table, for example:
Now in the login page (9999), create a process after Login to insert the user login date and time:
Then you would be able to show the last user login column in any report.
pavlos
Thanks a lot Vinish! But, how can I add source of login_datetime column on existing IR?
Vinish Kapoor
I assume that your interactive report based on any table must have the user_id column.
Then you should join the user_id column to get the last login date and time. For example:
This way, you can get the last_login_datetime column in your IR report.
Let me know if any queries.
pavlos
Thank you!
I thought I had to add a source outside the sql query 🙂
pavlos
Hi Vinish!
How I can store user clicks and page names for whole app?
Vinish Kapoor
Do you want to track clicks that have been clicked on the buttons or links or any click you want to track?
pavlos
Yes I do, I forgot to mention
Vinish Kapoor
Create a PL/SQL ajax process ("plsql_ajax_prc") in shared components as following:
Now on your page, add the following JavaScript code in the Function and Global variable declare section:
pavlos
Great!
How I can store button and link name?
Vinish Kapoor
I have added a few lines with comments to the above code:
pavlos
Works perfect!! Thanks a lot Vinish!
Now, I am trying to get nodeName of clicked element
pavlos
I tried but item is always empty.
Code: