Forum Discussion
Community Championpassing a calculated date parameter to multiple imports
Hi vanessafvg
What you could potentially do is the following.
In the Query Editor where you have created your Date going back 2 years, Convert this to a List.
Then create a new Parameter, when it asks for the Suggested Values, change this in the Drop Down to Query.
This will then give you an option for which Query to use.
You can now select the List that you converted above.
Now that you have it set as a Parameter, you can simply use this Parameter in your filters.
There is another way to do this, if it does not work, which is to manually create it in the Advanced Editor, but is a bit more complex. So if you can try the above suggestion first?
Super UserHi vanessafvg
What you could potentially do is the following.
In the Query Editor where you have created your Date going back 2 years, Convert this to a List.
Then create a new Parameter, when it asks for the Suggested Values, change this in the Drop Down to Query.
This will then give you an option for which Query to use.
You can now select the List that you converted above.
Now that you have it set as a Parameter, you can simply use this Parameter in your filters.
There is another way to do this, if it does not work, which is to manually create it in the Advanced Editor, but is a bit more complex. So if you can try the above suggestion first?
Helper II am having an issue passing date parameters to a pentaho web service, but when passing parameter as date it says:
We cannot apply operator & to types Text and Date.
Below is the call that is being made to the web service on my local machine.
Parameter name is date_start
Web.Contents("http://localhost:8081/kettle/executeTrans/?trans=E:\pentaho\dashboard.ktr&date_start="&date_start)
I can not use data type of the parameter as text as i have used slicer on the dashboard and that parameter is passed as the starting date to it, and it only accepts the date data type param.
what should i do with it?
- dearwatson
Continued Contributor
Hi shzincu,
Please post your quetion as a new topic.. this issue has already been solved so people are less likely to respond.
Not sure what you should do but I would try to cast the date to text before you append it? e.g.
Web.Contents("http://localhost:8081/kettle/executeTrans/?trans=E:\pentaho\dashboard.ktr&date_start="&Text.From(date_start))
sorry the syntax is probably wrong but I hop you get the idea.
