pentaho error when y put an oracle sql query with any parameter of data range input component

Good morning,
I have a sql that I enter in datasource and it shows me results. What I want is to put a date range input component and take the two parameters from there to pass them to the sql. In the sql, the parameters are set to $ date_from and $ date_to. Once I put it, the table is not shown, the query is erro. PLEASE HELP!!!

Can you share an image of the whole step configuration. might be you're not using variable substitution.

– Cristian Curti
Sep 6 '18 at 16:58

2 Answers
2

Here I show an image of how I have the layout panel configured.

enter image description here

Here I upload how I have configured the parameters

enter image description here

Here I show how I have configured the table where I will show the data

enter image description here

Here I teach how is the datasource and then I show the query

enter image description here

Thanks for contributing an answer to Stack Overflow!

But avoid …

To learn more, see our tips on writing great answers.

Required, but never shown

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

搜尋此網誌

Dfyjkt