Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Package Action Log */
4557 dpurdie 2 
/* Stange query attempts to retain the order of the entries */
3 
/* The date format is not strong enough to ensure correct ordering */
4 
/* The user should have used a timestamp instead */
5 
select alog.action_datetime,
119 ghuddy 6 
	   usr.FULL_NAME,
7 
       usr.USER_EMAIL,
8 
       acttype.description as acttype,
9 
       alog.description
4557 dpurdie 10 
       from (
11 
        SELECT  rownum as rn, action_datetime, ACTTYPE_ID, USER_ID, description
12 
        FROM ACTION_LOG
13 
        WHERE PV_ID = :PV_ID
14 
 ) alog
15 
   join USERS usr on alog.user_id = usr.user_id
16 
   join ACTION_TYPE acttype on alog.acttype_id = acttype.acttype_id
17 
order by alog.action_datetime DESC, alog.rn DESC