Hello all!
Has anyone been able to put a local view in system tables? Tessitura seems to be okay with supplying three of their own views into System tables, but the documentation and procedure seem to not like that for local things.
Fact is, I have a local table that I would like to put there. This table is just the perfect storm where a view would be able to be placed there (non-editable) and be done. Otherwise, I will have to put the table there and then schedule a job to regularly update the table to match the information in the database as it is updated. Not the hardest thing ever, but putting a view in place would just do away with the need for any sort of scheduled job entirely.
Thanks for any thoughts!
John
Hi John,
This is definitely doable! We have a number of views in the System Tables module, including control-grouped views of the TNEW tables so that our consortium organizations don't have to worry about overwriting or sifting through others' values. To do this I have a custom version of the stored procedure that updates that module (UP_POPULATE_REFERENCE_METADATA), although you have to be careful whenever service packs, upgrades, or other installations are run because when the canned procedure is run it removes those views from the module. I have allowances for that in my code, but that part can be a headache.
Katie,
I would love to get that script from you! That was where my brain was headed next, but I figured I would see if anyone else had any other ideas. Since you had the same thought, though, if I do not have to recreate the wheel...
And certainly, upgrades, service packs, etc... can potentially be irksome, understood. I will make sure to add keeping an eye on this to my list of upgrade tasks.
You have my e-mail, please and thank you very much!!
Lastly, for any Tessitura staff potentially watching this thread, this could make an excellent enhancement for Tessitura for consortiums!
John A. Moskal II
In reading your latest, this brings an interesting point to mind. Now that we have the new support system (no longer TASK), how do we share Enhancement Requests? Where have the "Shared Reports" Moved?
Karyn Elliott Melissa Champ can either of you share any insights?
I am not sure, thus my post.
See you in Chicago, Tom?
Hi Tom. Really good questions. Any shared code that a member would like to share with the community can be emailed to sharedreports@tessituranetwork.com. At this time, we do not yet have a landing page on the website for Shared Reports, but we are working on getting one. In the meantime, all shared reports are downloadable from the website. You can search the site for a report or simply search on the term "Shared Reports" to peruse.
More specifically, Feedback (aka Enhancement Requests) can be submitted through the support portal like any other ticket. Hope that helps!