Alteryx App with user input for In-DB Query

I've created an App where a user inputs a Date, Hour and Minute which changes the default inputs in the Filter and then creates a SQL query that is used for an In-DB query. When I run the Workflow with the default inputs the SQL gets generated correctly but when I run the App the entered date does not populate but the Hour and Time that was entered does. Has anyone ran into this and can assist?

I created a csv file where I can check the SQL that gets generated. Below you can see the difference when running the WF locally and then running the App from the gallery.

The error I receive from the Gallery:

Thanks in advance

Developer

Developer Tools

Apps

In Database

In-Database

Accepted answers

All comments

danilang

Hi @BonusCup

Check the action tools that you're using to update the date and time. Make sure that the correct line is selected and also that you're updating with values from the proper field.

Dan

BonusCup

@danilang here is what I have the Action and Filter configured to:

saralisset

Hi! I am new to Alteryx, but I have been requested to build something similar. Currently my report takes forever to run and this is because I pass the filters after doing select ALL. Can you please share screenshot of the right part of your workflow to give me an idea?

This is my workflow:

BonusCup

@saralisset the only difference it sounds like is that I don't do a select all. I'm only calling in the fields I need. Do you need every field in the table(s)?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703