cherylshah
Scout

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution

Sorry, I deleted the Query LDAP comment because I realized immediately after posting it that you're asking about a form not a workflow... But if it's somehow helpful, great! 🙂

0 Kudos
Reply
michaelbah40
Scholar

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution
yes i'm working in a form and not a workflow and I'm realizing this may not be what I need...the SQL is what i'm mostly familiar working in but I'm just baffled its not showing the data when I publish the form.
0 Kudos
Reply
cherylshah
Scout

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution

Especially since it works in your testing environment - it seems there would have to be a way to get it to work in production as well. Sometimes I've found with Nintex Forms that if you just delete a control altogether and then create it again from scratch, even if all the settings are identical to what you had before, the new one will work. Might just be a migration hiccup.

0 Kudos
Reply
michaelbah40
Scholar

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution
I figured out a work around using AD and the userprofilelookup command in my control, thanks for your assistance overall.
0 Kudos
Reply
michaelbah40
Scholar

Re: SQL Query works only in testing enviornment not in LIVE...

Jump to solution
0 Kudos
Reply