gallery chained app - workflow 2 input always cached

Question

Hi all,

I have a gallery app that contains 2 workflows.

workflow 1: user selects file, then, select which rows contains headers. Workflow 1 outputs to sql_Table

workflow 2: input = workflow1 output. user selects which columns contain product codes and supplier name (drop down with formula -> update tool -> dynamic rename)

issue: workflow2 seems to cache input data every time i run it in manual mode. the app does what it supposed to do, however no matter what file users selects, the workflow 2 will always have the same dropdowns (from the file i ran manually)

i tried to use sql tables as input/output in my projects, as well as .yxdb. Same behaviour.

Has anyone worked on a similar problem before?

Thank you in advance.

jakub_kola · Answer

OTrieger · Answer

Thanks. 
How do you get the data for the dropdown? As this is the place where you are facing the issue, no?

jakub_kola · Answer

@OTrieger, thank you ever so much for looking into this.
The input path in WF2 is defined as: odbc:DSN=Development DB
then, in options: 3. Table or Query -> i have an SQL query that selects all rows from the table.