Page 1 of 1

Upsert Cant Update Multiple

Posted: March 23rd, 2022, 11:41 pm
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

Re: Upsert Cant Update Multiple

Posted: May 15th, 2023, 11:44 am
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.