• Replies 3 replies
  • Subscribers 343 subscribers
  • Views 69 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

  • $organization

    Hi Jane,

    We currently don't have Delivery Method set up as List Criteria. However, I usually pull lists by Delivery Method using the Order Search screen. I'll search by Product and then filter by Delivery Method. Once I have that list of orders, I click the "List" button to save the constituents to List Manager.

    I hope this helps!

    Best,

    Acacia

  • $organization in reply to Acacia Barrow

    We have a custom criteria that hits a local view, but I'm with Acacia Barrow on using Order Search. 

  • $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.