• Replies 10 replies
  • Subscribers 337 subscribers
  • Views 50 views
  • Users 0 members are here
Related

help with Dddw_Where in T_REFERENCE_TABLES

Darrin Katz
$organization

I have created a custom table that I want to make available to users as a System Table. We are storing budget information for each prod_season_no and I want my users to be able to choose a production from a dropdown instead of relying on IT to provide the list of prod_season_no values.

I have added a season_no column to my custom table with the intent of letting users choose the season from a dropdown and then populating the prod_season_no values from another dropdown, just like in a Report. This will ensure that they choose the correct prod_season_no because we have many instances of the same production title being used in multiple seasons (though of course with unique prod_season_no values).

However, I am having trouble getting the Dddw_Where value for the prod_season_no column entry in T_REFERENCE_TABLES to "see" the selected value of the season_no column. What I want to do is the following:

 

column name: prod_season_no

Dddw_Table: t_inventory

Dddw_Value: inv_no

Dddw_Description: description

Dddw_Where: inv_no IN (select prod_season_no from t_prod_season where season = !.season_no)

 

This does not work. I am looking for a way to reference the selected season_no value. Any help on this matter would be very much appreciated.

Parents
  • $organization
    Hi Ryan,

    I have figured out that I could use something like this for the description
    of the prod_season_no:

    ( SELECT description
    FROM tr_season
    WHERE id IN (
    SELECT season
    FROM t_prod_season
    WHERE prod_season_no = inv_no
    )
    ) + ' - ' + description

    However, the Dddr_Description column doesn't allow nearly enough characters
    for me to input this entire thing. Is there a workaround for that?
Reply
  • $organization
    Hi Ryan,

    I have figured out that I could use something like this for the description
    of the prod_season_no:

    ( SELECT description
    FROM tr_season
    WHERE id IN (
    SELECT season
    FROM t_prod_season
    WHERE prod_season_no = inv_no
    )
    ) + ' - ' + description

    However, the Dddr_Description column doesn't allow nearly enough characters
    for me to input this entire thing. Is there a workaround for that?
Children
  • $organization in reply to Darrin Katz
    Yes, the workaround would be to create a view with a named column as the concatenation of season and prod season. Actually, I think Christian beat me to the punch here with his view "LV_SEASON_PRODUCTION". Here's from the previous post:

    Create view lv_season_production as
    select i.inv_no,(s.description + ' - ' + i.description) as Production , s.id as season
    from T_inventory i
    join t_prod_season p on i.inv_no = p.prod_no
    join tr_season s on p.season = s.id

    ______________________________________
    Ryan Creps
    Network Developer |Tessitura Network, Inc


    -----Original Message-----
    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Darrin Katz
    Sent: Tuesday, June 02, 2009 2:49 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] help with Dddw_Where in T_REFERENCE_TABLES

    Hi Ryan,

    I have figured out that I could use something like this for the description
    of the prod_season_no:

    ( SELECT description
    FROM tr_season
    WHERE id IN (
    SELECT season
    FROM t_prod_season
    WHERE prod_season_no = inv_no
    )
    ) + ' - ' + description

    However, the Dddr_Description column doesn't allow nearly enough characters
    for me to input this entire thing. Is there a workaround for that?


    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!

    No virus found in this incoming message.
    Checked by AVG - www.avg.com
    Version: 8.5.339 / Virus Database: 270.12.50/2150 - Release Date: 06/02/09 06:47:00