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!
Emily,
It may not be the most elegant solution ever, but you could probably create a local view without too much difficulty that has columns for the last 5 performances for each patron, and then create a few custom output set elements that reference that view.
I did something similar for an abandoned cart view to set up a triggered e-mail campaign against the information for people who left stuff in their carts but did not purchase. It works quite well.
John
If it actually turns out to be a processing time issue, and John A. Moskal II excellent idea about a view does not work and still times out. Open a TASK ticket and let the Network team know. However, you might have to create a SQL Server job and build a table or even stuff the results into an attribute, then pull that into the output set. (Attribute might not be a good idea. There might be a length limit.)