Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Alteryx App with user input for In-DB Query

BonusCup
10 - Fireball

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?

 

BonusCup_0-1620141164907.png

 

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.

BonusCup_1-1620141378419.png

 

The error I receive from the Gallery:

BonusCup_0-1620141578861.png

 

 

Thanks in advance

 

10 REPLIES 10
BonusCup
10 - Fireball

@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)?

Labels