Friday, September 22, 2017

Pull settings out of the columns of a SharePoint list with Nintext tasks to push records back to an MSSQL database.

This is doable. I don't really understand it end to end yet. The markup looks something like so:

UPDATE DeathNotice SET
EffectiveDate = '{ItemProperty:Effective_x0020_Date}',
Explanation = '{ItemProperty:Explanation}',
SupervisorComments = '{ItemProperty:Supervisor_x0020_Comments}',
ContactPhone = '{ItemProperty:Phone}',
IsCompleted = 1
WHERE DeathNoticeID = '{ItemProperty:Death_x0020_Notice_x0020_ID}'

 
 

_x0020_ here represents a space in the name of a column.

 
 

Addendum 9/25/2017: It's Nintex not Nintext. (groan)

No comments:

Post a Comment