Hi All,
In v11, the standard ticket history table (LVS_TKT_HIST) had a column of price type group. When we went to v12 we used the new standard ticket history table (VS_TICKET_HISTORY) and it no longer has the price type group column. We had a list criteria for price type group and now I can no longer find a way to build something in T_KEYWORD to have a list criteria for price type group. In the meantime, I'm writing SQL to plug into list manager so that users can still pull info on price type group but that doesn't feel like the ideal solution. I considered making a new local view that adds the price type group column in and having T_KEYWORD reference that view to pull price type group. However, when I use that criteria in list manager with another criteria that pulls the standard ticket history table, I'm getting inaccurate list pulls.
Anyone have any creative solutions to this problem? Is there a way to do a join within T_KEYWORD so that I can pull in the data on price type group while still using the standard ticket history?
Thanks!
Jenny Graf
You don’t need to create a new view or custom version of the ticket history table. You just need to add a sub-entity criterion. Sub-entity criteria evaluate sub-entities of other data entries, allowing you to reference data that does not have a constituent ID on it if you can tie it back to a parent entity that does have a constituent ID. In other words, you can reference data that’s not included in the ticket history as long as you can tie it to the ticket history in a single step. We had this in mind when choosing which data had to be included directly in the standard ticket history and which did not.
Here’s a link to the help topic that explains sub-entity criteria: http://www.tessituranetwork.com/Help_System_v125/Content/v12/Updates%20to%20Criteria%20Sets.htm
In this case, you would add a new criterion that evaluates the Price Type Category column in the TR_PRICE_TYPE table and then set the Parent Table to T_TICKET_HISTORY, the Parent Key column to price_type, and the Key Column to id.
Kevin Sheehan
Senior Technical Writer & Consultant
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com
This is very cool. There are all sorts of things one could do with this.
This is how we entered this. Anyone have suggestions for making this better?
Description = Ticket History Price Type Cat
Data Type = Number
Edit Mask [blank]
Detail tbl = TR_PRICE_TYPE
Detail Col = !.price_type_category
Ref Tbl = tr_price_type_category
Ref Idcol = id
Ref Desccol = description
Ref Where [blank]
Ref Sort = description
Category = Ticketing
Use For List = List Only
Multiple Value [Not Checked]
Control Group Whatever is appropriate for your orginization
Custom Id [Blank]
Custom Limit [Blank]
Custom Required [Not Checked]
Custom Default Value [Blank]
Incl In Basic Search [Not Checked]
Keyword Desc = Ticket History Price Type Catagory
Primary Group Default Not clear what is best to do here....
Parent Table = vs_ticket_history
Parent Key Column = price_type
Key Column = id
Help Text = Be sure to consider ticket history role. Performance will be enhanced if season is used in any ticket history query.