Hello my fellow Tessiturians,
I'm trying to take a look inside an output set to find where the source is for TM Performance Date, TM Performance Name and TM Price Type.
If I select the chiclet by any of those it pops up a box with 410 as the default and the current season shows as the drop down selections. This is as it should be. However next season, which comes up on September 1, we will need it to reflect the current season.
I may be barking up the completely wrong tree here, but I thought I'd explore.
I looked in several places:
T_QUERY gives me the query number of 71
TX_QUERY_ELEMENT gives me the three element numbers I'm interested in, 203, 204, 205
and TR_QUERY_ELEMENT tells me those are the correct names as above, and that they come from
lvx_tm_popi
any table that has TM in it is a mirror as I recall from boot camp.
Although I'm sure I'm wiser for the exercise, none of that got me any closer to figuring out what I needed to know, which is:
Where do I change the selection criteria in the output set the reflect the current season when the time comes?
Thanks as always,
Nick
Hi Nick,
If there is a chicklet on an output set element that allows you to select a parameter then it is a custom element (none of the standard elements use parameters). All parameters for output set elements are set up in the TR_QUERY_ELEMENT_PARAMETER table, which is where you set what is pulled to populate the parameter dropdown.
Here are some links to output set resources that might help (documentation and t-casts):
http://www.tessituranetwork.com/~/media/Documentation/Extractions%20and%20Lists/Output_Sets.ashx
http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/Marketing/Intro%20to%20Output%20Set%20Builder%20T-Cast.aspx
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
Thanks much Kevin,
So after doing some reading and looking at TR_QUERY_ELEMENT_PARAMETER , I see an entry that matches the parameter window that comes up in the output set.
The window where you select the parameter for which show, shows:
Production Title................................410
and the drop downs show the shows
If I look at TR_QUERY_ELEMENT_PARAMETER, there is an entry for Production title, and the "ref where" column says season=7
That appears to be where I would update the season. Does that seem reasonable?