Hi,
I have a workflow step that is an upsert and it's refusing to update and alwasy insert a record, i have even manually set the Lookupvalue and it still inserts.
I'm looking up on the table with a string value. Any help would be grateful.
Tim.
Hi,
I have a workflow step that is an upsert and it's refusing to update and alwasy insert a record, i have even manually set the Lookupvalue and it still inserts.
I'm looking up on the table with a string value. Any help would be grateful.
Tim.
Hi @Fordy,
Have you manually set the ItemId
on the key-value pairs to ensure that is working as expected?
Hi @Fordy! The behavior you're describing makes it sound like the filter that you're applying - ItemId
equal to B0002GV480
- isn't returning a record that can be updated. Can you confirm with a separate query that such a record exists?
Yep
It exists, it's the most strangest behaviour i have seen. I can even write a SQL statement and it updates the record. But UPSERT just won't work.
What kind of resource is this? Is it the built-in RetoolDB?
SQL server.
Can you share the equivalent raw SQL statement that is working for you?