Subversion Repositories DevTools

Rev

Rev 4670 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Package Action Log */
4670 dpurdie 2 
/* Note ordering by ROWID is a hack - the timestamp does not have enough resolution */
4653 dpurdie 3 
SELECT alog.action_datetime,
119 ghuddy 4 
	   usr.FULL_NAME,
5 
       usr.USER_EMAIL,
6 
       acttype.description as acttype,
4653 dpurdie 7 
       alog.description,
8 
       TO_CHAR(alog.action_timestamp, 'Dy DD-Mon-YYYY HH24:MI:SSxFF1') as action_timestamp
9 
  FROM ACTION_LOG alog, ACTION_TYPE acttype, USERS usr
10 
 WHERE alog.PV_ID = :PV_ID
11 
   AND alog.ACTTYPE_ID = acttype.ACTTYPE_ID
12 
   AND alog.USER_ID = usr.USER_ID
4670 dpurdie 13 
 ORDER BY ( TO_CHAR(alog.action_timestamp, 'YYYYMMDDHH24:MI:SSxFF') || alog.ROWID ) DESC
4653 dpurdie 14 
 
4670 dpurdie 15