cancel
Showing results for 
Search instead for 
Did you mean: 

Change Log Query

Former Member
0 Kudos

Does anyone have a query to list all purchase orders changed (Closed would be great) by a particular user name?

Regards,

Fred

Accepted Solutions (1)

Accepted Solutions (1)

former_member204969
Active Contributor
0 Kudos

You can start from this:

Select  b.DocNum,a.*  From
(SELECT T2.[U_NAME] , T0.[CardName], T0.[UpdateDate],  T1.[DocNum]
FROM ADOC T0 inner join OPOR T1 on T0.DocEntry=T1.DocEntry
INNER JOIN OUSR T2 ON T0.UserSign2 = T2.USERID WHERE T0.[ObjType]=22
Union all
SELECT T2.[U_NAME] 'UpdatingUser', T0.[CardName], T0.[UpdateDate],  T0.[DocNum]
FROM OPOR T0
INNER JOIN OUSR T2 ON T0.UserSign2 = T2.USERID ) A
inner join OPOR B on A.DocNum=B.DocNum
Where a.U_NAME='manager'
Order By b.DocNum
for browse

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Fred,

Try:

SELECT T2.[U_NAME] , T0.[CardName], MAX(T0.[UpdateDate]) 'Last Updated',  T1.[DocNum]

FROM ADOC T0 inner join OPOR T1 on T0.DocEntry=T1.DocEntry AND T1.DocStatus = 'C'

INNER JOIN OUSR T2 ON T0.UserSign2 = T2.USERID

WHERE T0.[ObjType]=22 AND T2.[U_NAME] LIKE '[%0]%'

GROUP BY T2.[U_NAME] , T0.[CardName], T1.[DocNum]

Thanks,

Gordon