• Replies 14 replies
  • Subscribers 339 subscribers
  • Views 625 views
  • Users 0 members are here
Related

Updating Constituent Interests based on a List

Former Member
Former Member $organization

Hi all,

Does anyone know of a quick way of updating Constituent Interests based on a list?  At the Royal Exchange, we have a list of people who have signed up to email in an external email system and we'd like the Constituent Interests for Data Protection to reflect that.

I've created them as a List in Tessitura so hoped there would be a handy update report (similar to the 'adding an attribute' one).  If not, would anyone be happy to share the sql?  With Ean Burgon, the only other similar example we found was much more complicated than we need (http://www.tessituranetwork.com/COMMUNITY/forums/t/4082.aspx).

The logic of what we're trying to do is: add a tick to Email_Yes (one of our Constituent Interests) based on a list but leave all the other Constituent Interests the same.  It's the logic of 'adding new rows' to the  tx_cust_tkw that we're struggling with.

Thanks

Mary

 

 

Parents
  • $organization

    I believe you could use something like:

    insert into TX_CUST_TKW
    (customer_no, tkw, selected)
    select customer_no,
    123, -- the tkw # you wat to insert
    'Y'
    from t_list_contents
    where list_no = 1234 -- your list_no
    where customer_no not in (
        select customer_no from TX_CUST_TKW where tkw = 1234 -- make sure they don't already have tkw
    )

Reply
  • $organization

    I believe you could use something like:

    insert into TX_CUST_TKW
    (customer_no, tkw, selected)
    select customer_no,
    123, -- the tkw # you wat to insert
    'Y'
    from t_list_contents
    where list_no = 1234 -- your list_no
    where customer_no not in (
        select customer_no from TX_CUST_TKW where tkw = 1234 -- make sure they don't already have tkw
    )

Children