Input tool is not pulling the most updated information from database

Question

Currently, I have an app that shows a list of departments that the user can select.  It looks like new departments that were added to the table are NOT showing up on my list. The list seems to be cached somewhere but I need to pull the most updated values all the time from the table.  I'm using an Input tool to pull the values from a database table and then populate a List Box.

Is there a configuration to run the select statement to pull the most recent values from the table everytime the App is triggered?

I do have Run PreSQL on tool configuration checked.   I apologize if this was answered previously.  I searched on the community and couldn't find an answer.

Thank you so much for your time.

SPetrie · Accepted Answer

Because of the way Alteryx is loading the app, its creating the list using the loaded options from the last time you ran the workflow in designer. If you want to have the items update automatically, you have two options that I know of.

1. Change the list box to use an external source for its values. You point it to a file with NAME VALUE fields that have your items in it, but that would require you to keep the file updated. Probably not the solution you want since you are pulling from a DB and want it to be as automatic as possible.

2. Alter this to be a chained app. Basically you create two applications, one to load in your department list and save it to a yxdb and then have it call a second app to then load that yxdb as the list of options. This is probably best solution for you. The training video in the link has a good walkthrough of creating a chained app.