I'm trying to use Execute SQL to lookup a column in an Azure DB, so that as the data is typed into the field in a Nintex form field, results are returned dynamically.
I have successfully managed to load about 100 records direct from the DB but the full list is quite large (10k+ lines) so I would like to see if I can access the data direct from the form field, by querying the DB table?
Not sure if this possible or if the performance would make this a bad option?
Well, unfortunately the action has its limitations - only 200 records per single query and column names cannot contain spaces (source: Execute SQL).
Just to be sure - you are trying to use the SQL Request Control, or Execute SQL action?
I'm using Execute SQL action.
I'm thinking of maybe making the field a free text entry field and then having a button to validate the entry against the DB, with some suggestions to choose from.
Definitely you must do some sort of pre-selecting a filter parameters, so that you can add them to the "WHERE" clause of your query... In Nintex Workflow you would be able to use the action in a loop, returning 200 rows in each loop. But on the form you are not able to do that, so the only option I see is to make the query to not returning more than 200 rows...