General Discussion

 View Only
  • 1.  Multi Value List or Multi Selection Button parameters

    Posted 11-24-2021 11:18
    I am trying to add either a Multi Value List or Multi Selection Button parameter to a report using the Pentaho Report Designer.

    What I have not been able to figure out is how to add that parameter to the query for the report.
    Can anyone help me?

    stanton schmidt
    Database Administrator/EDI
    direct. 920.471.4495

    cell. 920.660.1828

     

    RGL
    GO AHEAD.  ASK WHAT IF.
    www.RGLlogistics.com




  • 2.  RE: Multi Value List or Multi Selection Button parameters

    Posted 11-29-2021 08:18
    Assuming you're using SQL your parameter should be passed to an IN clause i.e
    SELECT 
      column
    FROM
      table​
    WHERE
      filterColumn IN (${parameterName})

    if you're using MQL  you can pass it as a regular constraint

    <constarints>
      <constraint>
        <operator>AND</operator>
        <condition>EQUALS([BusinessViewID.BusinessColumnID];[param:parameterName])</condition>
      </constraint>
    </constraints>





  • 3.  RE: Multi Value List or Multi Selection Button parameters

    Posted 11-29-2021 08:18
    Hi Stanton

    Like this.  The NameOfYourParameter inside ${} and used as an 'IN' clause.   Should come through as 'val1','val2','val3'

    ...INNER JOIN film ON film.film_id=inventory.film_id
    WHERE film.rating IN (${SelectRating})

    ------------------------------
    Andrew Cave
    Systems Engineer
    BizCubed Pty Ltd
    Australia
    ------------------------------