How do I create a list of items linked 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 exemlog2 e where soort='KOP'
and pid='10'
limit 999;
For this query, you will need to find the PID for the staff in question and substitute the number there. The PID can be found in the Manager, under systemWise > Access authorizations. Search for the staff person and use the Customer ID. You can use the exem_id (item id) from those results to look at the items via Items > Search.
If you want to use a query to identify the barcodes per item ID, that can be found in the exemplaren table. Replace the xxxxxx numbers with the exem_id numbers from the original query results.
select * from exemplaren e where exem_id in (xxxxxx, xxxxxx, xxxxxx);