Question

Query Data activity not returning rows from MS SQL table

Workflow Version 9

Updated August 11, 2015

asked on August 11, 2015

Hi all,

I have a workflow which needs to query for values (i.e Staff Name) from a MS SQL table. From the screenshot, when starting the Workflow, there is a field Staff List which needs to be populated dynamically according to the Staff Name results from the SQL table. I am getting an issue where the Staff List is not being populated and returning no results. I tried to test query and it is said '0 row(s) affected'

Thanks to advise where I go wrong.

Please see screenshots as attachments. The first one includes the activity name 'Assign Field Values' and the second one is the Query Data activity name.

1.jpg (87.08 KB)

| Download

2.jpg (82.48 KB)

| Download

0 0

Replies

replied on August 11, 2015

The only thing that I see is that you are retrieving the field value without waiting for that value to be changed. When your query data performs its query the value it is using for the "Alias" column is "Change me".

0 0

replied on August 11, 2015

If I'm following this correctly, I think Darrell is right. It's applying the metadata "Change Me" then retrieving it again right after. You should probably do a "Wait for Entry Change" after the "Assign Field Values 2" on whatever piece of metadata you want to search off (in this case, alias).

Basically your workflow looks like it's doing all in quick succession:

Assigned Template

Retrieved Template

Query

Basically, it's querying the Alias "Change Me" in your SQL Table.

0 0

You are not allowed to follow up in this post.

Question

Question

Query Data activity not returning rows from MS SQL table

Replies

Sign in to reply to this post.