Skip to main content
Nintex Community Menu Bar

SQL Request Cascade dropdown

  • June 13, 2022
  • 2 replies
  • 74 views
A
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
    • Garrett
    • Scout
    • June 13, 2022

    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

    A
    A
    Forum|alt.badge.img+1
    • AmolKhedekar
    • Author
    • Rookie
    • June 20, 2022
    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
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement