You are viewing limited content. For full access, please sign in.

Question

Question

Workflow "Update Data" activity with multiple criteria

asked on January 10, 2019

Maybe I'm going crazy here, but is it not possible to specify multiple Rows to Update criteria when configuring the Update Data activity? In other words, I want to say "update data where column1 == `abc` AND column2 == `def`".

The Query Data activity allows this type of basic boolean logic.

0 0

Answer

SELECTED ANSWER
replied on January 10, 2019

That's what I thought. This is a known issue on Windows 2008. We mitigated it some, but clearly there are still some cases. Unfortunately it's not easy to reproduce. The workaround is to use the Designer directly on the machine or connect with a remote Designer.

0 0

Replies

replied on January 10, 2019

Hi Ege,

You should just be able to keeping adding criteria ...

are you seeing something different?

1 0
replied on January 10, 2019

This is what I see:

The Add/Edit/Remove buttons are missing from the first section.

WF 10.2

0 0
replied on January 10, 2019

If you open the Errors pane in the Designer, is there anything in it?

0 0
replied on January 10, 2019

The one accessed from View > Error Log? It's empty.

0 0
replied on January 10, 2019

What is the OS? Is this over a remote desktop connection?

0 0
replied on January 10, 2019

Windows 2008 R2 over a remote desktop connection.

0 0
SELECTED ANSWER
replied on January 10, 2019

That's what I thought. This is a known issue on Windows 2008. We mitigated it some, but clearly there are still some cases. Unfortunately it's not easy to reproduce. The workaround is to use the Designer directly on the machine or connect with a remote Designer.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.