Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-5982

Cascading parameters are not reloaded on 7.0, 7.1 and 8.0 if using bean shell script

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: 7.0.0 GA, 7.1.0 GA, 8.0.0 GA
    • Fix Version/s: 8.2.0 GA
    • Component/s: None
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Steps to Reproduce:
      Hide
      • Create a prpt report with cascading parameters using bean shell script
      • Pentaho 5.4, 6.1: The drop down list for the second parameter will be reloaded after selecting value for the first parameter on the PRD and PUC if using Pentaho 5.4 and 6.1.
      • Pentaho 7.0, 7.1, 8.0: The drop down list for the second parameter will not be reloaded after selecting value for the first parameter on PUC, although it works fine on the PRD if using Pentaho 7.0, 7.1 and 8.0.
      Show
      Create a prpt report with cascading parameters using bean shell script Pentaho 5.4, 6.1: The drop down list for the second parameter will be reloaded after selecting value for the first parameter on the PRD and PUC if using Pentaho 5.4 and 6.1. Pentaho 7.0, 7.1, 8.0: The drop down list for the second parameter will not be reloaded after selecting value for the first parameter on PUC, although it works fine on the PRD if using Pentaho 7.0, 7.1 and 8.0.

      Description

      So here is the summary:
      5.4 and 6.1: It works both on PRD and PUC.
      7.0, 7.1 and 8.0: It works on PRD, but It does not work on PUC.

      Here is the fixing instruction I got from ESR-6232:

      This fix can be applied in ParameterXmlContentHandler#getDependentParameters - return null to disable caching.Then also alter #createParameterElement to ensure that the "must-validate-on-server" attribute is set to "true" for all parameter. This then bullies the client side code into pushing every change of selected values back to the server for revalidation, where the BeanShell scripts can do their magic.

        Attachments

          Activity

            People

            Assignee:
            scosta Sandra Costa
            Reporter:
            llu Lu Lu
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: