Home Discussions Questions & Answers Dependent parameters

Dependent parameters

Avatar photoCustomer June 15, 2023 at 2:19 am

I am setting up a Blitz Report and want to use dependent parameters to filter values in one parameter based on the selection in another. How do I define these dependencies in my LOV queries? Also, can I handle cases where the dependent parameter allows multiple values?

Viewing 0 reply threads
  • Author
    Replies
    • Support June 16, 2023 at 11:41 am  

      Hi,
      To set up parameter dependencies in Blitz Report, you can use the syntax :$flex$.parameter_or_lov_name. The parameter_or_lov_name should reference the name of the dependent parameter or the LOV (List of Values) name. This allows you to dynamically filter LOV results based on the value of another parameter.

      Key Details:

      1. Case-Insensitive References: The parameter or LOV name is not case-sensitive.
      2. Special Characters: Any spaces or non-word characters in the name are automatically replaced with underscores.
      3. Handling Multiple Values: If the dependent parameter supports multiple values, you can use the xxen_util.contains function in your query.

      Example:
      If you have an Operating Unit parameter that allows multiple selections, you can configure the query for an AP Supplier LOV to filter results based on the selected operating units using xxen_util.contains. This ensures that the LOV dynamically adjusts to the selected values of the dependent parameter.

      Additional Resources:
      For a detailed explanation of dependent parameters and how to implement them, refer to the Developer Guide:
      Blitz Report Developer Guide – Dependent Parameters

      If you need help with a specific query or configuration, feel free to reach out to us. We’re here to assist you!

Viewing 0 reply threads
  • You must be logged in to reply to this post.

Login with: