Update single column in a table (Update single field in cdt)

As @rodgraham mentioned above, what is called a "summary CDT" works well here. You make a CDT that, in the JPA annotations, maps to the correct table in the DB. It will have two fields:

the PK for that table
field you want to update

When you use a write to DB node in conjunction with this CDT, it will find the row in the table that corresponds to the PK of your CDT, and update the columns in the table that match up to the other fields in the CDT. You can use this to write one, or really as many fields as you want, which can be useful for various processes and events.

As @rodgraham mentioned above, what is called a "summary CDT" works well here. You make a CDT that, in the JPA annotations, maps to the correct table in the DB. It will have two fields:

the PK for that table
field you want to update

When you use a write to DB node in conjunction with this CDT, it will find the row in the table that corresponds to the PK of your CDT, and update the columns in the table that match up to the other fields in the CDT. You can use this to write one, or really as many fields as you want, which can be useful for various processes and events.