Skip to main content
Nintex Community Menu Bar

SQL Request Control - Not Populating

  • October 17, 2016
  • 2 replies
  • 17 views

Forum|alt.badge.img+6

When using the SQL Request Control, I am able to successfully connect to our database, and execute the query. When in preview mode, the control is failing to populate with any values. I've tried to change the Value and Display fields to different data types, but have the same results.

Configuration:

Results in preview:

2 replies

Forum|alt.badge.img+5

Try using PROJECT_ID in Value field and Display field.


Forum|alt.badge.img+13
  • Novice
  • September 18, 2017

Yes, The field in your query is PROJECT_ID but in the Value field and Display field you have ProjectID. This column doesn't exist in the results returned in your query.