I developed a workflow that is based on two main components. The first component writes data into a SQL database. The second component produces an excel report out of the SQL database. This second component contains a “Value selection” node which input comes from a DB Reader reading the SQL database.
I would like this input to be automatically refreshed each time the user executes the first component in order that the list showed in the dialog box of the second component takes into account the modifications of the SQL database.
What would work would be if the part of the DB reader node would be outside of the component. This way it would be possible that the value selection works on the read data table and automatically updated their possible values.
Please let me know if this is possible for you, I can also make an example if it is not clear.