• Replies 4 replies
  • Subscribers 337 subscribers
  • Views 153 views
  • Users 0 members are here
Related

Output Set Element for Last X Shows?

Emily Nash
$organization

#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! 

Parents
  • $organization

    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.

    Regards
    Sandra

Reply
  • $organization

    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.

    Regards
    Sandra

Children