cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
kyle_wright
Nintex Newbie

SQL Query that includes a field reference

Jump to solution

I'm building out my first Nintex form and have not been able to find an answer on this online so I'm hoping someone can help.

I'm trying to have a SQL Request field on my form be filtered by another field on the form.  I have the field working correctly if I don't attempt the filter.  I would essentially like to be able to say select field from table where parent='OTHER_FORM_FIELD'.

Is this possible?  I obviously need the field to refresh asynchronously after the other field is selected so i'm not sure this is possible.  Thanks!

Tags (3)
0 Kudos
Reply
5 Replies
Nintex Employee
Nintex Employee

Re: SQL Query that includes a field reference

Jump to solution

Hi Kyle,

We just released Nintex Forms 2.8 (SP2013) and 1.10 (SP2010) which has a lot of great enhancements to the SQL Request and Web Request controls. Included in this release is the ability to pass values into a query from other controls.

The release notes and downloads are available here. Please do let me know how you go with our latest release.

Cheers,

Euan

View solution in original post

Reply
kyle_wright
Nintex Newbie

Re: SQL Query that includes a field reference

Jump to solution

Awesome!  I'm installing in my test environment now so I can try it out.  Thanks!

Reply
baltner
Nintex Newbie

Re: SQL Query that includes a field reference

Jump to solution

This is just what I was trying to do using version 1.9 (SP 2010) and failing completely.  So I was very happy to read that v 1.10 was released and immediately downloaded and installed it.  However, I'm still not able to get this to work.  For example when I try to run this query:

SELECT LAST_FIRST_NAME, UID FROM EmployeeData WHERE UID = UsersNameControl

I get this error:

Test Result

Invalid column name 'UsersNameControl'.

so it appears that the UsersNameControl is being interpreted as a database column and not text.  Is there something that I should bhe doing here that I'm not?

Thanks,

Bruce

0 Kudos
Reply
dan_stoll
Nintex Newbie

Re: SQL Query that includes a field reference

Jump to solution

try SELECT LAST_FIRST_NAME, UID FROM EmployeeData WHERE UID = "UsersNameControl​"

Reply
baltner
Nintex Newbie

Re: SQL Query that includes a field reference

Jump to solution

Yup, that was it.  Thanks. -Bruce

0 Kudos
Reply