Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: PRD Parameters

  1. #1
    Join Date
    Jul 2017
    Posts
    3

    Default PRD Parameters

    I am new to this and not the sharpest knife when it comes to sql, I have used Infomaker but PRD is a bit differnt in it's format.
    I am trying to create a report straight from a spreadsheet that also contains images, so far so good all works fine, BUT, I need to add a parameter so that one column can be searched for keywords. I have added that paramter and then gone on to add the query in the data source, I have added this statement;
    SELECT * FROM query_name WHERE column_name LIKE CONCAT(${parameter_name} , '%'). This is where it falls over, I can't link the 2 bits together.
    I anybody is able to help it would be much appreciated, but please keep it simple.
    Thanks

  2. #2
    Join Date
    Aug 2016
    Posts
    142

    Default

    Your parameter syntax in the query looks fine, I just did a test one and it worked for me

    The only thing I can think of is the data type of the parameter. Is it set to String?

  3. #3
    Join Date
    May 2014
    Posts
    358

    Default

    query_name is the name of a table in the database?

  4. #4
    Join Date
    Jul 2017
    Posts
    3

    Default

    Sorry, only just seen this reply, yes it is set to 'string' but the query will just not talk to the parameter

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.