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!!