on 08-07-2005 3:21 PM
hi all..
can anyone help me. i wanna write a query to know who create a marketing document. i know we can track user by change log. but i want to do it using query generator so that i can see all of the documents and its user/creator, when i do query, i can't find any field related to user in the documents, such as ORDR, OINV, ODLN etc..
thanks in advance,
Bruce.
Something like this?
SELECT T0.DocNum, T0.CardCode, T0.CardName, T0.DocTotal, T1.U_NAME as 'Created by' FROM ORDR T0 INNER JOIN OUSR T1 ON T0.UserSign = T1.userid
HTH
Juha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
usersign on all docs join ousr to get name
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 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.