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.
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_noDddw_Table: t_inventoryDddw_Value: inv_noDddw_Description: descriptionDddw_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.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!
I would make a custom view that show all of T_inventory plus a column for season number by joining to t_prod_season and then you can use that as the Dddw_Table value. Then in your where, you can just say season = xx
Christian @ The Tech Museum
Darrin,
Sorry, I did not understand your issue correctly the first time. Now I see your dilemma. I am not 100% sure, but am guessing that what you are trying to do will not work. I guess the next best thing would be to use a view to at least show both the Season and production in the drop down list so the user can make the right selection. My view includes season number so you include a where clause to exclude old seasons if you want.
Create view lv_season_production asselect i.inv_no,(s.description + ' - ' + i.description) as Production , s.id as seasonfrom T_inventory ijoin t_prod_season p on i.inv_no = p.prod_nojoin tr_season s on p.season = s.id
Just a thought.