• Replies 2 replies
  • Subscribers 411 subscribers
  • Views 141 views
  • Users 0 members are here
Related

Inactive Constituencies

Julie Eskind Galbierz
$organization

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!

 

Parents
  • $organization

    Hey there! You could do a manual edit query in list manager.

    example:

    SELECT distinct
    a.customer_no
    FROM TX_CONST_CUST a
    WHERE 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.

Reply
  • $organization

    Hey there! You could do a manual edit query in list manager.

    example:

    SELECT distinct
    a.customer_no
    FROM TX_CONST_CUST a
    WHERE 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.

Children