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!!!

2 Answers
2

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

Here I upload how I have configured the parameters

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

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

Thanks for contributing an answer to Stack Overflow!

But avoid …

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

Required, but never shown

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.