Hi all,
We are looking at using multiple rankings (two membership orgs, each with a different rank type) and I have been modifying LP_CUSTOMER_RANK to account for this. Using my record as a test, I added both of the memberships to my record. I see both of the rankings when I select my id from T_CUST_RANK, but I only see one of the ranks on the Research tab/rankings button. Does anyone have some sample code they could share with me, or any idea where I might've gone wrong?Thanks!
Forgive me for suggesting something so simple, but could there be a control group issue in play here? Regular use of the database equates to an easy forgetting when inside Tessitura that your user might not have access to everything. Or so I have discovered in my own journeys.
Simple suggestions are sometimes the best ones. In this case, unfortunately, it doesn't apply because I have sys admin (all) rights. I did find some code snippets elsewhere in the forums that might help, though.
Did you double check that the memberships are in fact assigning a different rank type? I'm grasping at straws (and can't currently test this, our LP_CUSTOMER_RANK scripts are too...thorough), but maybe it doesn't like the rank value applied? Lastly, I expect the pane in the client is looking at VS_CUST_RANK, rather than T_CUST_RANK, so that might be something to try querying.
One more simple thing. Go back and check the record a second time. Is the rank there. If I remember correctly when moving from tab to tab another on a single client some values don't update. They only update and show when you re-open the specific customer's record.
At one time with Tessitura Prior to V11 we did have multiple membership organizations. However, in oue case, they shared a single web rank in order to do a mode of sales shifts for the web.
Just my $0.02
Thank you! It does appear that VS_CUST_RANK is what the client pane is looking at. And, in tracing everything back, I found one silly little mistake I made that explains why it wasn't reflecting what it should.