Skip to main content
Nintex Community Menu Bar

SQL request result not visible or not changable

  • November 10, 2017
  • 3 replies
  • 23 views

Forum|alt.badge.img+10

Hi all,

I have a query action within my form that gives back a number of project numbers as dropdown.

The user can choose whatever project number he wants out of that drop down list. Everything fine.

BUT

as soon as the user opens a saved entry in order to edit it, the project number is either

- empty (sql request is executed again within edit modus -> dropdownlist with all project numbers is displayed) or

- only the already selected project number is displayed (sql request is not executed within edit modus)

What I want is that the dropdownlist is available, BUT the already selected project number is still displayed (as selected).

Is there any way to solve this? I cannot imagine that I am the first one with this problem... sad.png sad.png sad.png

Jan von Reith‌, Cosima von Kries

Cheers

mai-kel

3 replies

Forum|alt.badge.img+1
  • November 13, 2017

I am having this issue too. It's really frustrating as this works with Infopath but not Nintex forms.

I am hoping someone has a solution to this issue.


Forum|alt.badge.img+14
  • Scholar
  • November 14, 2017

Forum|alt.badge.img+9
  • Novice
  • January 3, 2018

It sounds to me that it has been fixed in the recent Release notes, I'm having the same issue as well, I'm going to give the upgrade a try on a 2010 env. and see if that solves it. 

Nintex Forms 2010 - Release Notes 

Nintex Forms 2013 - Release Notes 

  • Fixed an issue where the SQL Request control may not retrieves values in display mode (00177023)
  • Fixed an issue where the SQL Request control may not display the ‘Please select’ default text option (00178718; 00187508; 00185211)

Check also my question here: