Hello All,
I'm a newbie to Tessitura but familiar with databases.
I'm looking at running this stored procedure, UP_REBUILD_SALUTATIONS, on a daily or weekly basis to refresh the "Salutation 1" and "Dear" fields on the constituent General tab screen.
It takes a list number as an input parameter. My question is, if the list is defined as a dynamic list, will this procedure trigger a dynamic refresh of the list?
Is there a way of running this stored procedure from Tessitura directly?
Thanks
Hi Ian,
You could create a report with the parameter settings you wanted the end user to have, and then write a stored procedure that takes those inputs and executes UP_REBUILD_SALUTATIONS. I would expect that the dynamic list would regenerate, but not 100% sure about this if you’re executing straight from SQL (I would probably test it out in a test environment to be sure). If it doesn't, then you could execute RP_GENERATE_LIST in you SProc before you run UP_REBUILD_SALUTATIONS – it will regenerate any list you give it, not just dynamic lists.
One last thought….depending on what your users’ needs are, you could also set UP_REBUILD_SALUTATIONS to run on a schedule using SQL Server Agent. That’s what we do and we haven’t had the need for front end users to execute it thus far.
Hope that helps,
Natasha
Thank you all for your replies!
We'll probably build a list on a daily basis, excluding those special Development and VIP salutations, and feed that into the UP_REBUILD_SALUTATIONS which we'll schedule through SQL Server.
Problem solved.
Many thanks