Complex List Box from external source to In-DB Filter

[bryanbumgardner]

Hello,

This slightly overlaps with similar posts on In-DB filters but I have a new specific problem. 

I am creating an app that allows for a list box selection generated from a table in a database. This "flights" table is updated each day via an API, so any changes are immediately reflected in all apps connected to it. There is a one-to-many relationship between the "flight name" and the "flight IDs" contained in this table - many IDs can be part of a single "flight." 

In the database table that needs filtered, only these IDs are present, no "flight names" are present. Therefore, the List Box tool must achieve the act of allowing users to pick specific "flight names" and then on the back end concatenate all flight IDs into a form that can be passed into an In-DB filter tool. This concatenation must happen each time the workflow is run (I can't just make a static table) because the IDs can change at any time without warning. 

In the past, I had a macro that updated a static file and the list box tool simply looked at that file. The workflow was like this: 

However, this is inelegant and annoying. I need this to run on the Gallery and minimizing assets is going to be better. Here's what I've tried to do, but this doesn't work because the string coming from the List Box tool is incorrect and doesn't contain the "flight ID" concatenation from the top part of the workflow, which needs to get passed to the filter.

Here's a broken idea:

I'm looking for some Alteryx superheroes to help! If you can figure this out, I'll buy you a drink at Inspire this year where I'll be speaking! 

Cheers,

- Bryan 

[BenMoss · Accepted solution]

I think you need to check out chained apps!

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Chained-Alteryx-Analytic-Applications/ta-p/7...

Ben