There are two ways to get this report, depending on what you need.
Go to Reports | Other reports | Export email | Edit the query
- For a list of all bar code scans for a performance, use this query:
select concat(auth, chartlist_id) from chartlist left join chartdata using(chartdata_id) where shows_id=<shows_id> - For a list of all bar code scans for a chart, use this query:
select concat(auth, chartlist_id) from chartlist where chartdata_id=<chartdata_id>
This is an example of what the report looks like:
