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

Cannot pass multi-value parameter to kettle data sources

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.9.0 GA (4.5.0 GA Suite Release), 3.9.1 GA (4.8.0 GA Suite Release)
    • Fix Version/s: 6.0.0 GA
    • Labels:
      None
    • 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.

      Description

      A multi-value parameter with post-processing function CSVTEXT() is turned into a regular string. Unfortunately this string parameter cannot be passed to a Kettle Datasource. Instead of the parameter string, a string array or java object is passed in and converted to a string using .toString().

      A workaround that seems to work is to create a copy of the original parameter with formula =[original_parameter] and use this to pass down to kettle.

      Attaching minimal samples. Please see screenshots for the defect and expected result.

        Attachments

        1. broken_parameter_passing.png
          broken_parameter_passing.png
          16 kB
        2. expected_parameter_passing.png
          expected_parameter_passing.png
          16 kB
        3. foo.ktr
          17 kB
        4. foo.prpt
          5 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              schodnicki Slawomir Chodnicki (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: