• Replies 3 replies
  • Subscribers 343 subscribers
  • Views 70 views
  • Users 0 members are here
Options
Related

List Manager Criteria - search by ticket delivery method

Jane Trembley
$organization

Hello everyone,

I might be missing something obvious... But is there a way to use ticket delivery method as criteria in List Manager? Or is this something I would need to use SQL for?

We need to send different pre-show information to people depending on what type of ticket they got, so that is the reason for this. 

Thank you all so much and I hope everyone has a great week.

Jane

Parents
  • $organization

    Hello everyone! We figured it out in SQL. Here is the code that will get you your owners and recipients. 

    Select o.customer_no

    FROM T_Order o
    JOIN T_SUB_LINEITEM l on o.order_no = l.order_no
    Where l.perf_no = [PERF_NO]
    And o.delivery = 9
    AND recipient_no IS NULL
    UNION
    Select recipient_no
    FROM T_Order o
    JOIN T_SUB_LINEITEM l on o.order_no = l.order_no
    Where l.perf_no = [PERF_NO]
    And o.delivery = 9
    AND recipient_no IS NOT NULL
    You'll just need to choose the delivery id number you want from the T_Order table. 
Reply
  • $organization

    Hello everyone! We figured it out in SQL. Here is the code that will get you your owners and recipients. 

    Select o.customer_no

    FROM T_Order o
    JOIN T_SUB_LINEITEM l on o.order_no = l.order_no
    Where l.perf_no = [PERF_NO]
    And o.delivery = 9
    AND recipient_no IS NULL
    UNION
    Select recipient_no
    FROM T_Order o
    JOIN T_SUB_LINEITEM l on o.order_no = l.order_no
    Where l.perf_no = [PERF_NO]
    And o.delivery = 9
    AND recipient_no IS NOT NULL
    You'll just need to choose the delivery id number you want from the T_Order table. 
Children
No Data