Upsert Cant Update Multiple

This forum allows users to post and respond to "How Do I Do ....." questions. The information contained in this forum has not been validated by K-Rise Systems and, as such, K-Rise Systems cannot guarantee the accuracy of the information.
Post Reply
CathyC
Posts: 469
Joined: November 16th, 2021, 11:15 am
Contact:

Upsert Cant Update Multiple

Unread post by CathyC »

I am receiving the following error
1.PNG
Should an upsert be able to update multiple?

I think we built this to update one, but its a cleanup service and is supposed to mark it inactive so if there are multiple the right action is to mark all inactive. Wondering if theres a use case where it'd be bad to allow upsert to update multiple and thats why the restriction is in place
word count: 72

Tags:
SteveCap
Posts: 327
Joined: August 26th, 2021, 9:18 am
Contact:

Re: Upsert Cant Update Multiple

Unread post by SteveCap »

We did have an internal discussion about this. At the time we decided that Upsert should only really be used to update/insert a single record which is why we kept the keys instead of replacing it with the where clause builder.
word count: 42
Post Reply