Dynamically write query based on User Input in App

Is there a way to have a query write in where clauses after the user selects and inputs text in the interface when they go to run the analytical app?

Example: Text Box Tool: What Color do you want to query for? The User types in Blue

I want my query in the dynamic input tool to write in under the where clause: and color = 'Blue'

Developer

Interface Tools

Accepted answers

AngelosPachis

Hi @jordanmount6 ,

@NicoleJohnson has written a blog on this that might seem handy to you and answer a few of your question. Adding the link below if you haven't come across it already

https://community.alteryx.com/t5/Engine-Works/Creating-a-Custom-SQL-Query-Builder-App/ba-p/893385

All comments

apathetichell

I do this with dynamic input in-db. Basically have your query in a text input and have the action tool change/add whatever dependencies you want for your query. I'd recommend using a list box or drop down though to lock the user into the kinds of fields/values which should appear in your WHERE clause.

AngelosPachis

Hi @jordanmount6 ,

@NicoleJohnson has written a blog on this that might seem handy to you and answer a few of your question. Adding the link below if you haven't come across it already

https://community.alteryx.com/t5/Engine-Works/Creating-a-Custom-SQL-Query-Builder-App/ba-p/893385

jordanmount6

So i've made a workflow with a check box that is grouped with an action tool for a text box so they can select what they want to query for but my problem comes in when alteryx doesnt like commented out lines in the sql.

jordanmount6

Thank you @AngelosPachis that is what i am looking for. Appreciate you

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703