Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Call multiple parameters from URL - Date parameter as a string in URL

  1. #1
    Join Date
    Feb 2013
    Posts
    530

    Default Call multiple parameters from URL - Date parameter as a string in URL

    Hi Forum,

    I'm unable to call multiple parameters from URL .. both of string type

    localhost:8085/pentaho/api/repos/ublic:Explore:CDEExploring:TestassParametersFromURL.wcdf/generatedContent?userid=admin&password=password&instId=312&Date=01/03/2014

    I'm using 2 custom parameters for these 2 parameters rather than simple and Date parameter as suggested here ..

    http://forums.pentaho.com/showthread...865#post358865

    and in the java script component writing below code for each ,individually

    for instId
    function sendParam(){
    return Dashboards.getQueryParameter("instId");
    }

    for Date
    function sendParam2(){
    return Dashboards.getQueryParameter("Date");
    }

    SQL query in CDA - Working without any issue :

    to_char(m.bus_date(+),'mm/dd/yyyy')='01/03/2014'
    AND
    b.inst_id in (SELECT inst_id FROM inst_master)
    AND to_char(b.inst_id)='312'
    )


    When I take only instId parameter it is giving correct output( Date is static).
    When I add Date as string it is going into infinite loading of the dashboard..

    Any suggestions on this will be appriciated


    Thank you.
    Sadakar

  2. #2
    Join Date
    Feb 2013
    Posts
    530

    Default

    The problem is with the parameter name : Date , changed it to param2_Date .. every thing remained same..

    Don't know the reason why I can not give custom parameter names as Date ....

    If any one have any idea not to give custom parameter name as "Date" , please comment in this thread..


    Thank you.
    Sadakar
    BI developer

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.