• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 29 views
  • Users 0 members are here
Related

Re: Adding Prod Season intoListManager criteria

Tina Treants
$organization
Ryan,
Here are the columns for the table and an actual record value 
Thanks again
Tina
 
tck_no 463963805
customer_no 169037
performance_name All Staff Ceramics  
performance_code E8AC103   
performance_dt 10/17/08 5:00 PM
matinee_or_evening E
tcK_amt 45
ticket_type R
num_seats 1
registrant Jenna Kluth         
price_type FULL      
comp_code_reason                               
seat_location GA:C-3
source_code 1424
season 168
mos_category 14


>>> "Ryan Rowell" <bounce-ryanrowell5634@tessituranetwork.com> 05/30/2012 4:23 PM >>>

What columns do you have in that table? Can you list them for us?

Do you have any like season, season_id, or season_no? If so that is probably what you want to use.

From: Tina Treants <bounce-tinatreants8809@tessituranetwork.com>
Sent: 5/30/2012 4:38:59 PM

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!


--
View this message online at http://www.tessituranetwork.com/Community/forums/p/7339/23049.aspx#23049 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
  • $organization in reply to Ryan Rowell

    Hey Tina -

    Without knowing how much access to the DB you have, you'd have to do a join on your local ticket history table out to some more tables to get production season. That isn't actually stored in your local table. 

    I know lots of people have custom views which link productions, prod season, seasons together - I'm still using one from Andrea Crain in Chicago (thanks Andrea!). If you let us know how much (if any) SQL access and knowledge you have, I'm sure more suggestions will start flying!

    - Heather