on 11-09-2012 3:10 PM
Does anyone have a query to list all purchase orders changed (Closed would be great) by a particular user name?
Regards,
Fred
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.