Hi
How does an Interest get a selected value of N in TX_CUST_TKW? When I unselect an interest on a constituent record, it deletes from that table instead of its selected value changing from Y to N.
I am asking because I am trying to build output set elements to use with WordFly for our preferences. I need a value of 1 if the interest is selected and 0 if it is not. The element is built and the 1 is returning fine, but I am not getting any 0’s since I don’t have any interests with a selected value of N. The patrons who don’t have the interest selected are just getting a blank cell returned.
Thanks Jess Levy San Francisco Opera 415-551-6319
That's what I have in Data Select for Interests IIF(!.selected = 'Y',1,0). You add this to an Output Set as many times as many Interest Categories you have.
Jess Levy said:How does an Interest get a selected value of N in TX_CUST_TKW? When I unselect an interest on a constituent record, it deletes from that table instead of its selected value changing from Y to N.
There are a couple of cases. One is when manipulating them externally via the REST API, a service may choose to just de-select. I think TNEW does this. The other case is if a "weight" has been applied to the Interest, in which case it will stay around even if de-selected.
Success! Thanks so much!
Thanks for the info.