Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Parameter parsing issue in mysql query

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Jan 2012
    Posts
    2

    Default Parameter parsing issue in mysql query

    Hi,
    please help me to solve the issue.
    uisng prd 3.8.1

    the parameter ${choice} is not working. all other parameters are working fine but the parameter in the DATE_FORMAT format function is not working properly

    ${choice} is a dropdown parameter, containing values "deposit_date" or "prd_date"

    DATE_FORMAT( ${choice}, "%Y-%m-%d")
    BETWEEN
    STR_TO_DATE(${From Date}, "%Y-%m-%d") AND
    STR_TO_DATE(${To Date},"%Y-%m-%d")
    Last edited by sarijans; 06-13-2012 at 04:41 AM.

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.