Hello lovely Tessitura people,
I'm attempting to write a View which will pull availability data from TW_WEB_PRICES, however this table doesn't include all the performances which should be available online. Is this expected behaviour?
I can't seem to work out why certain performances are missing, and was wondering how often this table is populated and what triggers it's population? (Is that the right terminology? I'm quite new to this SQL stuff...)
Many thanks for your help
GraemeYoung Vic Theatre
Hi Graeme,
Good day.
Is this TW_WEB_PRICES a custom table? because I couldn't find it in our SQL.
have fun
Ben
Hi Ben, Thanks for that.
I'm pretty sure it isn't a custom table. In fact, the reason you couldn't find it is cos it's called TW_GET_PRICES... Silly me
Thanks again
Grae
TW_GET_PRICES is populated each time a call for performance or package pricing is made from the web. It is filled with the valid pricing as of the time the order is made for the MOS, source_no, etc. It is a "work" table (thus the TW prefix) and therefore its contents are temporary. It is used to pass the pricing information between several stored procedures, using the spid field to identify which information is for the current session.
So, unfortunately, building views or reports from this information would not be very useful.
David