how to use the dynamic input with a Oracle SQL query

[ivoiculescu2020]

Hello everyone,

I contact you hoping you can assist me (again): I need to run a Oracle SQL query showing the shipment details for studies. When I run this query in Alteryx, I would like to configure it to give me the option to input a specific study ID and/or a date range the shipments have been generated in.

Do I use the dynamic input for it? Or do I necessarily have to create a dynamic app?

any help you can provide is welcome and appreciated.

Thank you!

Kind regards,

Ioana

[abacon]

Are you wanting to allow a user to input their desired parameters? You would need an alteryx app to do that regardless of the input tool used. However, a dynamic input tool should do that job. From your requirements, it appears you should be able to pass your desired parameters to it and if you don't have any new params, just use a default value.

[ivoiculescu2020]

@abacon 

Hello,

Yes, I want to be able to put the desired parameters (study ID, a specific date range etc) when running the query.

do you know how I can configure the dynamic input? or do you have any examples I could use?

thank you!

[abacon]

@ivoiculescu2020 You would want to configure the dynamic input tool like you are doing a normal input tool with your sql query. Then, you would do modify SQL query and do either Update WHERE Clause and select the fields that include your chosen parameters. If the where you clause you want to update doesn't appear, you can do replace the specific part of your where clause with the desired tools. How you want to configure the app is a different process though. You need a tool that takes the inputs, pass it to a Text input tool and prep the data to make sure it matches how you want it to go into the SQL query. I have attached a dummy example with the list box. I haven't configured the DB but the settings are what you would need.

I find the best options are either a drop down or a list box so the user can't fat finger or input the wrong params when running the workflow.

[abacon]

If this worked for you @ivoiculescu2020, please accept this as a solution.