How do I create a list of items ordered by specific staff members?
Applies to
- Wise configuration
Answer
This information can be gathered by running the following query in the Manager at systemWise > Reports > Report processor, on the Queries tab:
select *
from bestel_verzoek where
userid = '[actor ID]'
limit 999;
If you need to find titles associated with those items:
select *
from bestel_aanbod where
aanbod_id in
(select aanbod_id from bestel_verzoek where userid = '[actor ID]')