• Replies 4 replies
  • Subscribers 962 subscribers
  • Views 67 views
  • Users 0 members are here
Related

Pulling Patrons with Expired Constituency

Laura Chalmers
$organization

Good morning!

We have a program for students that we call NEXT. What we do is we put a NXT constituency on the constituent that we set to expire when they graduate. I just got a request that we want to solicit our LYP program to former NEXT buyers which means I will need to pull a list of people who used to have NXT constituency on their account but expired between 2019-2022. Is there a way to do that in Tess?

Thanks!

Parents
  • $organization

    I've done this with SQL Query in list  manager  for past staff, just change the dates and the constituency ID:
    Select Distinct c.customer_no
    From T_CUSTOMER AS c
    JOIN (SELECT const.customer_no FROM TX_CONST_CUST AS const WHERE const.constituency in (11) AND const.end_dt BETWEEN '2000/07/31' AND '2023/07/31') AS e ON e.customer_no = c.customer_no
    Where IsNull(c.inactive, 1) = 1

Reply
  • $organization

    I've done this with SQL Query in list  manager  for past staff, just change the dates and the constituency ID:
    Select Distinct c.customer_no
    From T_CUSTOMER AS c
    JOIN (SELECT const.customer_no FROM TX_CONST_CUST AS const WHERE const.constituency in (11) AND const.end_dt BETWEEN '2000/07/31' AND '2023/07/31') AS e ON e.customer_no = c.customer_no
    Where IsNull(c.inactive, 1) = 1

Children