Hi, I've created a STU constituency to add to accounts who have bought a student price type and had their ID checked when their tickets were scanned. I identified them via the Attendance by Performance report, saved to list and added using the Manage Constituency Utility. This was very quick & easy, but ideally I'd like to schedule the process going forward. However, I can't schedule saving a report to list and I can't find the right criteria to create a dynamic list - people who bought a student price type and were scanned in (during x period). Any ideas how I can automate this? Sadly I don't write SQL (yet).
Adding to what Nathanael's idea.
What if you create two dynamic lists:
List A, with criteria of Attendance Date >= RunDate -1
List B, with any performance criteria with student price type that HAS List A. ( you could also add criteria for those who Do Not Have the constituency already)
You could then use List B in the manage constituency report.
I think that would get you the students you are looking for.
Hope that helps.
T.C.
Yes, I'm going to +1 this! I do it with attributes and it works great!