mai-kel
Process Pupil

SQL request result not visible or not changable

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...   

Jan von Reith‌, Cosima von Kries

Cheers

mai-kel

0 Kudos
Reply
3 Replies
blevinsl
Canvas Initiate

Re: SQL request result not visible or not changable

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.

0 Kudos
Reply
emha
Automation Master
Automation Master
cmikhaiel_e
Workflow Veteran

Re: SQL request result not visible or not changable

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:  

Reply