Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Passing parameter to xaction query

  1. #1
    Join Date
    Mar 2007

    Default Passing parameter to xaction query


    Probably a very simple thing I'm missing, I have a http request parameter that I need to pass to the sql query in an xaction as part of the where clause.

    where key = {PREPARE:key}

    I have created an input to the action called key with 'request' as the source and the key is part of the http request to the jsp containing the ChartHelper object. The error message is that "key" has a NULL value.

    Should I be passing it in to SimpleParameterProvider in the jsp or via some other mechanism?


  2. #2
    Join Date
    Mar 2007


    Yip - was something silly:

    In my action-definition I needed to add

    key type="string"

    I hadn't spotted this as I needed to edit the XML rather than use the Solution Designer.

    as well as add it to the SimpleParameterProvider in the jsp:

    parameters.setParameter("key", key);

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.