Question

Query Criteria - 0 Rows Affected in result

Workflow Version 12

Updated March 20

asked on March 19 • Show version history

Please see the attached workflow - when I "Test Query" I get 0 rows affected. When I run a test, in the tokens for the Query Criteria there is nothing despite the document having all fields populated.

0 0

Answer

SELECTED ANSWER

replied on March 20

I figured it out - the issue is with Tag1 and Tag2. I actually didn't need those columns in the query just because I was using the data later in the conditional decisioning. Having them there without a value to reference was causing my problem.

2 0

Replies

replied on March 19

Hi Vikki, I'm a little confused and was wondering if you could supply some more details as to what you are doing.

When you click the "Test Query..." link for the Query Data activity it should popup a window where you can enter values for it to use for your test. Are you populating those values or just clicking OK?

You said, "despite the document having all fields populated". By documents, do you mean rows in the table you are querying?

Have you tried running the same SQL query in SSMS and do you get results?

0 0

replied on March 19

Hiii Vikki!

When you say zero rows affected, did you pick like "C-Entity" from the actual table in the database, place a value in it (to test) and it came back with nothing? It won't matter if all the fields in the template are filled out. You need to make sure the data exists in the SQL table (COR_Access Tags) since that is what the query is looking for.

0 0

You are not allowed to follow up in this post.

Question

Question

Query Criteria - 0 Rows Affected in result

Answer

Replies

Sign in to reply to this post.