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
I forgot to ask. When we rollover to the new season, does that automatically update the mirror tables?