Skip to main content
Nintex Community Menu Bar

SQL Request Cascade dropdown

  • Jun 13, 2022 11:44 AM UTC
  • 2 replies
  • 105 views
  • Translate All

Forum|alt.badge.img+1

Hi All,

 

I am trying to load data from SQL sever on selection simple dropdown value but its not working and not loading value in SQL Request dropdown. Please check below details.

 

SELECT TOP 1000 [ABC]
,[Job Type]
,[Company]
,[JobStatus]
,[Job Description]
FROM [SharePointTest].[dbo].[Test_JobsInformation] where Company='CompanyVal'

 

"CompanyVal" is selected dropdown and added in SQL where condition.

 

Can anyone help me on this, Please let me know if you required anything from me.

 

Thanks,

Amol K

 

 

 

2 replies

Garrett
Forum|alt.badge.img+16
  • Scout
  • Jun 13, 2022 12:35 PM UTC

Hi @AmolKhedekar 

 

Pls have a look at this.

Solved: SQL Request Control – Cascading Multiple Fields fr... - Nintex Community

SQL Request Control Cascading Dropdown Not Working - Nintex Community

 

If the data in the database does not change frequently, why not populate the data into SharePoint Lists? Its much easier to do Cascading Dropdowns using SP Lists

Translate

Forum|alt.badge.img+1
  • Author
  • Rookie
  • Jun 20, 2022 1:24 PM UTC
Thank you so much for this. I have simple dropdown and need to cascade with SQL Request and my dropdown values loading using jQuery.
I will check and let you know

Thank you so much
Translate