• 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
    Unknown said:
    Curious if someone out there has an easy solution for creating a list of records where a desired constituency is inactive.

    Hi, Max. Tess provides a View that makes this easy:

    select a.customer_no
    from TX_CONST_CUST a
    where not exists (
    select 1
    from VX_CONST_CUST_ACTIVE b
    where a.customer_no = b.customer_no
    and a.constituency = b.constituency
    )
    and a.constituency = 1 -- substitute desired const ID

    Could be used in List Manager or elsewhere. 

Reply
  • $organization
    Unknown said:
    Curious if someone out there has an easy solution for creating a list of records where a desired constituency is inactive.

    Hi, Max. Tess provides a View that makes this easy:

    select a.customer_no
    from TX_CONST_CUST a
    where not exists (
    select 1
    from VX_CONST_CUST_ACTIVE b
    where a.customer_no = b.customer_no
    and a.constituency = b.constituency
    )
    and a.constituency = 1 -- substitute desired const ID

    Could be used in List Manager or elsewhere. 

Children
No Data