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

SQL Request Control – Cascading Multiple Fields from SQL Database Table

Jump to solution

Using Nintex Forms 2013 on-premise, I created a form and set a SQL Request Control to display customer’s ID from SQL database table.

Upon ID selection (field: customerID), I need to pull back 3 other fields. customerFirstName, customerLastName and customerEmail. All fields reside in same table.

 

SQL Request control works fine returning a single value such as:

Display field:   customerID

Returning:       customerLastName

But it doesn’t work at all when I try to return multiple values such as:

Display field:   customerID

Returning:       customerLastName, customerFirstName, customerEmail

I used SQL query with Concat() option and tried selecting fields using Alias name (to be used in Value field). All failed.

Can it be done?

How can I resolve this issue?

Thanks

Eric

Labels: (3)
Reply
12 Replies
Highlighted
Nintex Newbie

Re: SQL Request Control – Cascading Multiple Fields from SQL Database Table

Jump to solution

Hi Eric,

You can use

select customerLastName + '-' +  customerFirstName + '-' + customerEmail AS CustName from Customer

View solution in original post

Reply
Highlighted
Nintex Newbie

Re: SQL Request Control – Cascading Multiple Fields from SQL Database Table

Jump to solution

Thanks Mathew.

It works fine now.

Eric

Reply
Highlighted
Not applicable

Re: SQL Request Control – Cascading Multiple Fields from SQL Database Table

Jump to solution

Hi, Eric Rozensher​, are you able to select a "correct answer" from this thread? If so, it's helpful to other community members seeking answers to questions like yours. Thanks!

Frank

Your community manager

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: SQL Request Control – Cascading Multiple Fields from SQL Database Table

Jump to solution

Hi Eric

Can you please add a screen shot of this working? I am trying to do the same.

Thanks

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: SQL Request Control – Cascading Multiple Fields from SQL Database Table

Jump to solution

Hi Sojan

Can you please share a screenshot of this working?

Thanks

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: SQL Request Control – Cascading Multiple Fields from SQL Database Table

Jump to solution

Hi Abhi,

what screen shot do you want

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: SQL Request Control – Cascading Multiple Fields from SQL Database Table

Jump to solution

Of the action please if you can.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: SQL Request Control – Cascading Multiple Fields from SQL Database Table

Jump to solution

Hi Abhi,

Unfortunately that was a project for a client. data is not available to me anymore.

I wish I had a snapshot.

I apologize.

Eric

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: SQL Request Control – Cascading Multiple Fields from SQL Database Table

Jump to solution

Hi Eric

Where can I input the formula above?

0 Kudos
Reply