Hi. I'm trying to update a field in a column only when the corresponding field in a request I'm rece...

# exposed

[Linus]

Hi. I'm trying to update a field in a column only when the corresponding field in a request I'm receiving is not null. Here's what I want to do in pseudo code that isn't working:

transaction {
    Table.update({ Table.id eq targetId }) {
        it[someField] = if (request.someField != null) { request.someField } else { it[someField] }
    }
}

How can I do something like this?

[AdamW]

Assuming you’re updating other fields also:

request?.someField?.let { value ->
  row[column] = value
}

[Linus]

Interesting, thanks!