• Replies 5 replies
  • Subscribers 961 subscribers
  • Views 216 views
  • Users 0 members are here
Related

Finding expired constituencies in a list

Former Member
Former Member $organization

Hi all, 

Curious if someone out there has an easy solution for creating a list of records where a desired constituency is inactive. For example, looking for board members whose constituency was end-dated for the end of their board term. Being able to search for this in List Manager would be great, but I'm curious for any solution out there. 

Thanks!

Max Williams

Stanford Live

Parents
  • $organization

    Here's the SQL I use in List Manager. Just change the constituency number (in my example 1) and constituency end date range (or delete the end date range all together).

    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 (1) AND const.end_dt BETWEEN '2018/07/31' AND '2018/08/01') AS e ON e.customer_no = c.customer_no
    Where IsNull(c.inactive, 1) = 1

Reply
  • $organization

    Here's the SQL I use in List Manager. Just change the constituency number (in my example 1) and constituency end date range (or delete the end date range all together).

    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 (1) AND const.end_dt BETWEEN '2018/07/31' AND '2018/08/01') AS e ON e.customer_no = c.customer_no
    Where IsNull(c.inactive, 1) = 1

Children
No Data