Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Query for Multiple Select Component

  1. #1
    Join Date
    Jul 2017
    Posts
    6

    Default Query and info for Multiple Select Component

    Hi,

    I have a problem with the multiple select component for select different months in a sql query.
    The query is:

    SELECT DISTINCT Month
    FROM activity
    WHERE Mese=(${param1})

    This is a simple example to explain my problem, if I select one month in the multiple select component it work but obviously if I select more than 1 it doesn't work. How can I do to pass two or more month?

    Thanks!
    M
    Last edited by matsoc; 08-06-2017 at 02:24 AM.

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    Your query is not correct. Use IN in the where statement when multiple values
    SELECT DISTINCT Month
    FROM activity
    WHERE Mese IN (${param1})

  3. #3
    Join Date
    Jul 2017
    Posts
    6

    Default

    Quote Originally Posted by johanhammink View Post
    Your query is not correct. Use IN in the where statement when multiple values
    SELECT DISTINCT Month
    FROM activity
    WHERE Mese IN (${param1})
    Thank you, tomorrow I will try.

    Is possible to list all the values of the multi select component horizontally? How?

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.