Re: Adding Prod Season into ListManager criteria

Ryan
That is exactly what is wrong, our LP_tck_hist (yes, it is a table- eek) does not have the prod season in it! No wonder it never worked because I had the values just as yo listed below.
Now what?
Thanks so much, I can stop beating my head against an immovable wall now.
Tina
>>> "Ryan Rowell" <bounce-ryanrowell5634@tessituranetwork.com> 05/30/2012 2:00 PM >>>

Hi Tina,

Since local tables can vary from org to org, it is hard to tell you what your column information should be. If you can confirm that the table has a !.prod_season column it would probably be similar to our Season column, which would make it...

Data Type = Number
Edit Mask = (blank)
Detail Tble = (name of your local table)
Detail Col = !.prod_season
Ref Tbl = vrs_season
Ref Idcol = id
Ref Desccol = description

If you have not confirmed that there is a production season column I would suspect you don't have one.
Also, most local tables start with LT not LP, which suggests you are pointing to a local procedure which would not work.

From: Tina Treants <bounce-tinatreants8809@tessituranetwork.com>
Sent: 5/30/2012 1:46:46 PM

We have tried for some time to add Production Season into List Manager as a criteria for lists. We do have a local ticket history table LP_Tck_hist. Can someone please layout the values needed for the various columns. I keep getting an Invalid Column Name error with regard to my value of !.prod_season. in Detail Column

Thanks in advance for your help.

Tina



--
View this message online at http://www.tessituranetwork.com/Community/forums/p/7332/23034.aspx#23034 or reply to this message
--
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Parents Reply Children
No Data