Hi everyone,
We have a constituency for our School parents, with end dates corresponding to the end of the last enrolled semester. Therefore, all of our spring 2012 parents have "School Parent" constituencies that are now inactive. Is there a way to pull a list of these folks in List Manager?
Thanks!
Hey there! You could do a manual edit query in list manager.
example:
SELECT distincta.customer_noFROM TX_CONST_CUST aWHERE a.constituency=18 and a.end_dt='2012-7-29'
Change the highlighted constituency number to the corresponding number for "School Parent" and end date to the end date of the semester. That should work.
Done and done. Thanks so much, Travis!