Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Pass Date Variable

  1. #1
    Join Date
    Jan 2018
    Posts
    13

    Default Pass Date Variable

    How can I pass date variables to table input . I want to run my sql query between two dates start date and end date

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    So, you have a Table-Input step with a SELECT statement having a WHERE clause with a condition like "date_expr BETWEEN low_date AND high_date", and you are looking for a way to keep the interval bounds variable?

    Essentially, you've got 2 ways:

    • With a reference like ${low_bound} you can have variable substitution, i.e. option "Replace variables in script" will trigger textual substitution of the references before the statement is prepared.
    • A question mark (?) signals, that you want field substitution, i.e. fields from an incoming row are bound to the parameters of the prepared statement.
    So long, and thanks for all the fish.

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.