Hi Rahul,
This should do the work.
SELECT T0.Code AS 'Stock Code', T1.ItemName AS 'BOM Desc', T0.CreateDate as 'Date BOM Created', T2.U_NAME as 'BOM Created By', T0.UpdateDate as 'Date BOM Updated', T3.U_NAME as 'BOM Updated By' FROM OITT T0 INNER JOIN OITM T1 ON T1.ItemCode = T0.Code INNER JOIN OUSR T2 ON T2.USERID = T0.UserSign LEFT JOIN OUSR T3 ON T3.USERID = T0.UserSign2 WHERE T0.CreateDate BETWEEN [%0] AND [%1]
Kind Regards,
Diego Lother
Hi,
Have you tried with standard "Change log" function for history?
Let me know still you need query.
Thanks
Hi Nagarajan
The standard Change log function can check only one stock code at a time
With the query
I can find out by date range. How many stock codes were created? Created by whom? How many were modified? Modified by whom?
Yes please I need the query
Thanks
Add comment