We are beginning to send out automated performance reminders using wordfly. We are running into a problem pulling performance synopsis information. Has anyone else had this issue? We have not been able to create an output set that can pull this information.
Hi Nick,
We created a local_view which pulls the data we need for output into a table that can be referenced in output set up.
I can send you the SQL we used but we also have custom ticketing tables in place and a very simple performance structure in place - i.e did not solve the multiple emails if same perf in one day problem.
Let me know if you would like more info on our set up in case it helps drive some ideas for you.
Thanks
Louise
Hi Louise,
That would be great. If nothing else, it may help spark some ideas.