Home › Discussions › Questions & Answers › Using Parameter Values for Default Value SQL (Dependent Parameters)

Using Parameter Values for Default Value SQL (Dependent Parameters)

Avatar photoCustomer Questions & Answers 5 replies

I need to set the default value for Parameter B based on the user’s selection for Parameter A (e.g., defaulting a specific supplier list based on the chosen Operating Unit). How do I reference Parameter A in the default value SQL for Parameter B?

5 replies

  • Support Enginatics

    To define parameter dependencies in default values, you must use the syntax: :$flex$.parameter_or_lov_name.

  • Avatar photoCustomer

    So if Parameter A is ‘Operating Unit’, and I want to append ‘suppliers’, what would the default value SQL look like?

  • Support Enginatics

    The default value should start with ‘select’ if it is derived dynamically. An example using concatenation might be: select :$flex$.operating_unit||’ suppliers’ from dual.

  • Avatar photoCustomer

    When referencing the parameter name, should I use the exact name, including spaces?

  • Support Enginatics

    The parameter name must be the name in the installed base language (usually US), prefixed with a colon, and with spaces or other non-word characters replaced with a single underscore (e.g., :$flex$.operating_unit).

  • You must be logged in to reply to this post.