Martin Baumgartner Posted March 14 Share Posted March 14 Hi My goal is to load data on-demand from our sql server. As input parameters I use a pre "calculated" table with our deficit input parameters, except the time. Previously I did a "select distinct date .." on the data, but this query takes a while. Is there a way to use a date slider or date picker to get the values as parameters for my on-demand loading. All input parameters ca be set by custom filters in a text box. The data loading will be started on button click. Would be great if somebody can help me. Regards Martin Link to comment Share on other sites More sharing options...
Solution David Boot-Olazabal Posted March 14 Solution Share Posted March 14 (edited) Hi Martin, You can find a date picker here: https://spotfired.blogspot.com/2014/07/two-popup-calendars-start-and-end-date.html. The dates that you have set, has to be stored in a document property. And that document property can then be used as a trigger for the on-demand query. In the below example (not on a date field), you can see how to set a property as input for an on-demand query: Kind regards, David Edited April 4 by David Boot-Olazabal Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now