Subversion Repositories DevTools

Rev

Rev 4653 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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