Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to get values from a query with parameter?

  1. #1
    Join Date
    Aug 2017
    Posts
    12

    Default How to get values from a query with parameter?

    Hi ther guys,


    I have a dashboard with two parameters and a select (I have a bit more but the problem is here).
    Here is my sqlJndi query:

    SELECT
    ID, NAME
    FROM
    table1
    INNER JOIN table2 ON tabl1.ID=table2.ID
    WHERE
    table1.ID = 7
    AND table1.PERMISSION BETWEEN 20 AND (CASE ${userRole}
    WHEN '80' THEN 80
    WHEN '60' THEN 60
    WHEN '40' THEN 40
    WHEN '20' THEN 20
    END)

    ORDER BY
    table1.ID,
    table1.POS


    What I want to achieve, is when I set userRole to a value (80, or someone else), I get the values of the query in other parameter like param1 or whatever.

    I've tried it with Parameters in the sqlJndi component ({userRole, userRole},{param1, param1}), but param1 is always empty, so my select component too.


    I hope you can help me.

    Thanks.

  2. #2

    Default

    https://forums.pentaho.com/showthrea...e-in-CDE/page2 . The last comment is the answer I have posted hope it helps you out!

    Pentaho 7.1 & CTools

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.