| 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
|