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!
I think this might require a custom list criteria so pull in the start and end dates for constituencies. I just checked our Dev v16 environment and the interactions cube doesn't have constituency expiration dates either. Given that we can have multiple instances of constituencies in v16, this seems like criteria we need. Something for the ideas board, I think.
Thanks, Anne!
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_noFrom T_CUSTOMER AS cJOIN (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_noWhere IsNull(c.inactive, 1) = 1
IT WORKED! Why is it every time a SQL query works for me I think it's magic?? Thank you!