Hello,
I've received a request to change the level of an inactive membership. It doesn't appear to be possible in the membership screen of the history tab. I have some SQL that modifies the level in TX_CUST_MEMBERSHIP based on the cust_memb_no, and I've tested it--works fine.
UPDATE TX_CUST_MEMBERSHIPSET memb_level = <new membership level>WHERE cust_memb_no = <insert cust_memb_no>
Pretty simple, right? I'm just wondering if anyone else has had to do this and if so, are there any other considerations that I'm not thinking about?
Thanks in advance,
Michael Dorsey
Hello Michael!
This is Iliana with Tessitura Network Support. We’re happy to assist you with this question. I’ve created a Support ticket where we’ll work with you to find a resolution to this question. We’ll also relay our findings from that ticket in this forum post, but if you have any other questions or concerns in the meanwhile please let us know.
Best,Iliana
Thanks, Iliana!