Simple update into a database using the Query Database smart service

Dear all,

I would like to make a quick update to just one database column and trying to use the Write to Database smart service, I am required to populate all the other fields.  Because I do not need to start getting all the other fields just so I can update on field, I am trying to use the Query Database smart service instead.

I have the following simple database update query:

UPDATE cshvcashadvancedata SET currentstatus = "Manager Rework -test has worked" WHERE id = ac!requestId

In the setup tab, I defined the above query.

In the data input tab, I added an ac (see screenshot below).  However, the database update is not getting performed. I also noticed that Appian automatically added a new input node - ~1.requestId (I'm not sure what that is for).

Is there anything I am missing?

Thanks

 

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data