• Replies 7 replies
  • Subscribers 702 subscribers
  • Views 142 views
  • Users 0 members are here
Options
Related

I need help with creating list

Amber Sanders
$organization

I need assistance on pulling the following lists for our Ticket Office.  I am at a lost on how to pull the lists. Can someone help me write sql query to create the the list in Tessitura?

  1. Any MC subscribers that have 2 or more orders of the same subscription series for this current season (FY23). 
  2. Any MC subscribers that have an initiator for their FY23 MC Subscription order. (I have no idea how to pull the initiator criteria)
  3. Any FY23 MC Subscribers that have been merged since 1/1/22 (I can figure out the accounts that were merged but not the date they merged) 

Any help is appreciated.  

Thank you, 

Amber Sanders

Parents
  • $organization

    Hi Amber,

    The first item in your list is more suited to the functionality of Reports and Utilities. I would try the following:

    In Reports and Utilities, run the the Subscription Detail by Constituent report for the season you're looking for. Save the report as a .csv file. Open the file and highlight the customer_no column, then select Conditional Formatting in the toolbar > Highlight cells rules > Duplicate values. That should tell you if any subscribers have multiple orders.

    You could also try this with the Package Order listing report to cross reference and see if that gives you better data. 

Reply
  • $organization

    Hi Amber,

    The first item in your list is more suited to the functionality of Reports and Utilities. I would try the following:

    In Reports and Utilities, run the the Subscription Detail by Constituent report for the season you're looking for. Save the report as a .csv file. Open the file and highlight the customer_no column, then select Conditional Formatting in the toolbar > Highlight cells rules > Duplicate values. That should tell you if any subscribers have multiple orders.

    You could also try this with the Package Order listing report to cross reference and see if that gives you better data. 

Children