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

SQL request control, server name and DB name, to be dynamic

In SQL request control, Server name and Datbase name as seen below,

how to make them based on Reference Sharpoint list values, in order to avoid manuall edit when moving them from development to production SharePoint server.

ie, how to let server name be a dynamic constant variable?

Labels: (1)
0 Kudos
Reply
5 Replies
thanker
Nintex Newbie

Re: SQL request control, server name and DB name, to be dynamic

Any News 

0 Kudos
Reply
abdullahfahmi91
Nintex Newbie

Re: SQL request control, server name and DB name, to be dynamic

My suggestion is, you can create a Workflow Constant of String type to store the server name and database.

Make sure Sensitive is untick.

You can limit this Workflow Constant to only be able to be used by certain user.

Only these certain user can then see this Workflow Constant inside Insert Reference in Server and Database field in SQL Request Control.

0 Kudos
Reply
Nintex_Man
Nintex Newbie

Re: SQL request control, server name and DB name, to be dynamic

Did you ever find a solution for this?
0 Kudos
Reply
Nintex Employee
Nintex Employee

Re: SQL request control, server name and DB name, to be dynamic

@Nintex_Man are you able to advise provide more information about the solution you are trying to acheive?

0 Kudos
Reply
Nintex_Man
Nintex Newbie

Re: SQL request control, server name and DB name, to be dynamic

I just submitted a new post (link below). We have a Development environment and a Production environment for SharePoint/Nintex and a Database. The Nintex forms use the SQL Request and I'm trying to find a way to have a database alias or some way to have dynamic data in the database server field so we do not have to edit the Nintex code when importing it to Production.

https://community.nintex.com/t5/Nintex-for-SharePoint/How-to-use-a-Development-and-Production-Databa...
0 Kudos
Reply