on 01-05-2015 5:38 AM
How to include Client name /IP in approval decision report?.I wrote this query but it output some duplicated values with all the machine names in my domain.
SELECT USR5.ClientName,DocNum,CardCode,CardName,OWDD.OwnerID,USR5.ActionBy,WDD1.Status,OWDD.WtmCode,OWDD.Status,ODRF.DocDate,DocDueDate FROM ODRF
INNER JOIN OWDD ON ODRF.DocEntry = OWDD.DocEntry
INNER JOIN WDD1 ON OWDD.WddCode = WDD1.WddCode
INNER JOIN OUSR ON WDD1.UserID = OUSR.USERID
INNER JOIN USR5 ON OUSR.USER_CODE = USR5.UserCode
WHERE ODRF.DocDate = '20150101'
order by DocDate
Hi,
Try:
SELECT distinct USR5.ClientName,DocNum,CardCode,CardName,OWDD.OwnerID,USR5.ActionBy,WDD1.Status,OWDD.WtmCode,OWDD.Status,ODRF.DocDate,DocDueDate FROM ODRF
INNER JOIN OWDD ON ODRF.DocEntry = OWDD.DocEntry
INNER JOIN WDD1 ON OWDD.WddCode = WDD1.WddCode
INNER JOIN OUSR ON WDD1.UserID = OUSR.USERID
INNER JOIN USR5 ON OUSR.USER_CODE = USR5.UserCode and OUSR.USER_CODE = USR5.[ActionBy]
where OWDD.docdate = USR5.date and ODRF.DocDate = '20150101'
order by DocDate
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
10 | |
9 | |
5 | |
3 | |
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.