There is a requirement for the user to be able to select date/dates.It use to be used in a SQL query and have that query execute. How would I do this?
I am thinking of the below workflow.
Date1 >= user_input_date1
So before the Database reader node containing this query is executed, a pop up box would prompt the user to enter/select a date and the date would replace the “user_input_date”. after this, the node would execute.
QuickForm nodes are a bit outdated. Nowadays we use configuration nodes for the AP and Widgets for the WebPortal. If your user uses the workflow in the Analytics Platform, wrap the Date&Time Configuration in a component and pass the selected value as a flow variable to the database node. The user can then configure the component by picking a date.
Yes the users will be using the Analytics platform. However, I was thinking a more user friendly form style like a pop up form or something.
Also I tried what @AlexanderFillbrunn suggested the data base node is throwing an error “got number format expected date”.
that may be because the node outputs the date as a string. You may have to convert it into a date within SQL.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.