• 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

    For number three, this SQL in a list should get you what you want.:

    select
	distinct m.kept_id as customer_no
from T_MERGED as m
where status = 'S'
	and m.merge_dt >= CONVERT(datetime, '2022/01/01')

    This isn't doing any household expansions, and I don't know off the top of my head if you can set up a manual query that will allow household operations?

    Edit: Advanced Relationship Options work just fine with this.

Reply
  • $organization

    For number three, this SQL in a list should get you what you want.:

    select
	distinct m.kept_id as customer_no
from T_MERGED as m
where status = 'S'
	and m.merge_dt >= CONVERT(datetime, '2022/01/01')

    This isn't doing any household expansions, and I don't know off the top of my head if you can set up a manual query that will allow household operations?

    Edit: Advanced Relationship Options work just fine with this.

Children