Hi,
Could someone tell me how to change the performance name that appears in the dropdown in List Manager for "Ticket Performance Name"? It seems like a simple thing to change until I scoured over "Production Elements" and could not find where to change it. We have two performances that are coming up in the list with the same name.
Thanks,
Lou Ann
Which field that is may vary, depending on what your org has in t_keyword for "Ticket Performance Name". I think the default behaviour is that it grabs performance name from the ticket history table, but what field THAT is would also be dependent on how your org populates lt_tkt_hist. So you may have to backtrack a couple layers to figure out where it's coming from.
Hi Lou Ann,
The standard version of this criterion uses a text field not a dropdown, so it’s hard to say exactly what will solve your issue but I can give you a few pointers that might help.
The first thing you have to determine is what data that criterion is actually looking at. Many times when a description is displayed in the dropdown it is really only there for reference; in actuality it is using the ID number attached to that description. That is the most likely cause of duplicate performance names. If you have two performances of the same event, they are going to have the same name but two different IDs. Selecting one over the other will actually give you different results, as while the descriptions are the same and indistinguishable, the IDs behind them represent two different performances. For this reason it’s probably best if your dropdown displays performance codes instead of performance names, or a combo of the two.
You can find out what the criterion is looking at by right clicking on it in the criteria list which will display this window (see site for screenshot):
This is a shot of the standard criterion. You can see that the data type is String (i.e. text). If yours is Number that's the first clue that it's looking at IDs. The Detail Tbl and Detail Col tell you exactly what the criterion is looking at, though if you don't actually know what data is stored in the column it is looking at (the column name doesn't always help) that won't help much. Finally the Dropdown Tbl tells you what table it's getting the performance names from your dropdown. To get the rest of the details of how the dropdown is populated, and to make any changes, you need to go to the T_KEYWORD table and find the row for the criterion. If Ref Idcol in T_KEYWORD is set to ID, perf_no, or inv_no then it is definitely looking at performance IDs but displaying performance names. If it is set to something like description then it really is looking at performance names. In that case you can probably fix it by changing it to distinct(description), which means it will only pull each performance description once.
You can find explanations of all the columns in the T_KEYWORD table in the System Tables document.
I hope that helps!
-Kevin
Thank you for the responses. We were eventually able to solve our problem by changing the "short name" for each performance on the front-end, and then running the procedure: lp_udate_tkt_hist.