• 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
    As a temporary workaround I am using the following as my Dddr_Where value:

    inv_no IN ( select prod_season_no from t_prod_season where season IN (
    select id from tr_season where inactive = 'N' ) )

    This ensures that only one production title is listed at a time to avoid any
    confusion, however my users are limited to inputing data only for active
    seasons.
Reply
  • $organization
    As a temporary workaround I am using the following as my Dddr_Where value:

    inv_no IN ( select prod_season_no from t_prod_season where season IN (
    select id from tr_season where inactive = 'N' ) )

    This ensures that only one production title is listed at a time to avoid any
    confusion, however my users are limited to inputing data only for active
    seasons.
Children
No Data