#Repost from Ticketing & Customer Service
Good afternoon,
Our Telefund team is asking to see the last 5 shows seen by a patron. I ventured into the v14.1 Output Set Element Cookbook and found the LFS_TICKET_HISTORY_STRING solution, providing me with a string of performances separated by a comma in one field. Even after tweaking this to pull in only the top 5 performances, Tessitura is timing out when pulling this information from a large list. v14.1 provided us with the FT_ELEMENTS_FIRST_OR_LAST_N_CONTRIBUTIONS for contributions, but I have been unsuccessful in finding something similar for ticketing. I would think pulling these into individual query elements would cut down on the resources used to pull this information vs. within a single string.
Any out-of-the-box suggestions or custom solutions?
I look forward to hearing from you. Thanks!
Hi Emily
I am working on modifying FT_ELEMENTS_FIRST_OR_LAST_N_CONTRIBUTIONS for doing the last 5 perfs for Ticket History for the Output Set Cookbook.
If you are still interested in this, let me know your email and I'll send you the details as to what is required for setup etc. Although it is using a Function, I am hoping that it may perform better when used with a large list.
RegardsSandra
Has there by chance been any update or solution for this?
Thank you!