If you have usage tracking enabled then you could get it from the V8_event_vw table.if the BQY is run in web client.
What is the VB_Event_Vw table ? where do I find it ?
Its not VB its V8 .The one which I mentioned get created when you enable usage tracking for IR from the workspace.
Where do I finf the "enable useage" setting ? I can't find it.
The simplest approach is to add a column to your Request Line
Name: Run Date Time
formula (Oracle SQL): TO_CHAR(TRUNC(SYSDATE), 'YYYY-MM-DD HH24:MI')
Then you have the date and time of the query/results when it was run.
then just make a text label on your dashboard and in the startup of dashboard set the text property of the text label to the getCell() of your Run Date Time column.
If the solutions provided please mark the question closed and acknowledge the contributors appropriately. If the solutions do not answer your question please let us know where you need clarity.