• Replies 3 replies
  • Subscribers 413 subscribers
  • Views 24 views
  • Users 0 members are here
Related

3 or More Productions

Marie Kocher
$organization

I am trying to pull a list of constituents who have purchased 3 or more productions out of 9 specific productions. These need to be PAID orders, not comps of any kind. These constituents can have ANY combination grouping of 3 of the 9 productions. Any help is appreciated. This is cross posted in other forums as well.

For Example, out of the multiple possibilities of 9 productions, I would want to see a constituent record with purchases to production 1, 4, and 9; or 2, 3, and 7, etc.

Parents
  • $organization

    We have a criteria set item called “Tickets – Number of Unique Perfs” that we use for this.  Combine with a date range and a set of price types and you can probably get what you want.  If the date range is not continuous, you may need to pull some lists and combine them, then use the “Number of unique perfs” criterion.

     

    I don’t know if this is a custom item, or something that comes standard with Tessitura.

     

    Jane

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Marie Kocher
    Sent: Wednesday, November 02, 2016 3:28 PM
    To: Jane Voytek <jvoytek@berkeleyrep.org>
    Subject: [Tessitura Development Forum] 3 or More Productions

     

    I am trying to pull a list of constituents who have purchased 3 or more productions out of 9 specific productions. These need to be PAID orders, not comps of any kind. These constituents can have ANY combination grouping of 3 of the 9 productions. Any help is appreciated. This is cross posted in other forums as well.

    For Example, out of the multiple possibilities of 9 productions, I would want to see a constituent record with purchases to production 1, 4, and 9; or 2, 3, and 7, etc.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    We have a criteria set item called “Tickets – Number of Unique Perfs” that we use for this.  Combine with a date range and a set of price types and you can probably get what you want.  If the date range is not continuous, you may need to pull some lists and combine them, then use the “Number of unique perfs” criterion.

     

    I don’t know if this is a custom item, or something that comes standard with Tessitura.

     

    Jane

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Marie Kocher
    Sent: Wednesday, November 02, 2016 3:28 PM
    To: Jane Voytek <jvoytek@berkeleyrep.org>
    Subject: [Tessitura Development Forum] 3 or More Productions

     

    I am trying to pull a list of constituents who have purchased 3 or more productions out of 9 specific productions. These need to be PAID orders, not comps of any kind. These constituents can have ANY combination grouping of 3 of the 9 productions. Any help is appreciated. This is cross posted in other forums as well.

    For Example, out of the multiple possibilities of 9 productions, I would want to see a constituent record with purchases to production 1, 4, and 9; or 2, 3, and 7, etc.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data