How To: Create a Report listing Stock Creation Dates

To produce a report featuring all stock items, including the dates they were created and the user who created them, copy, paste and run the following SQL in the Report section of Khaos Control;

select sk.stock_code, ast.event_time, ul.user_name
from stock as sk 
inner join audit_stock as ast on sk.stock_id = ast.stock_id
inner join user_list as ul on ul.user_id = ast.user_id
inner join stock_option as sko on ast.stock_id = sko.stock_id 
where ast.event_type = 2
and sko.discontinued = 0

See Also

Did you find this article helpful?