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

Question

Question

query data returns no results after running the first time

Workflow Version 9
Updated January 18, 2016
asked on January 14, 2016

I'm performing a small data migration of about 6000 files with MetaData. I created an test CSV which I uploaded into an SQL Table that I am calling into from the workflow. This solution is for a 1 time import, and as I haven't used the SDK before, so this appeared to be the best way as it's a 1 time solution. I created a WF test which ran fine and read all of the rows in the table and added the files to the repository. I added Assign Values after the first test to assign the MetaData, but now when I run the WF again to test or even try the Test Query it returns no records. Thoughts?

 

0 0

Replies

replied on January 15, 2016

I think you need to remove all your Query Criteria columns as you are currently searching where each item is blank right now. It is my understanding you want to return all the rows in the table. To do this just remove all the columns from your query data activity and it will still return all the columns as results.

As for your assign field values, make sure you are not Assigning the field values to the starting entry as it should be targeting your create entry activity.

2 0
replied on January 18, 2016

Thanks, removing all of the columns queried all of the rows.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...