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

Question

Question

Database query is filling in metadata with same results instead of each unique result

Updated June 1, 2015
asked on June 1, 2015

I can’t see what I am missing in the workflow.  I am doing a database query to return multiple results for each search.

When I test the query I get the correct number of rows (in my test example I get 6 results back based off the inputted number).

However, when I track tokens and what is put in the template is 6 entries of the first result instead of all 6 entries having different information.

Thanks.

 

    

0 0

Answer

SELECTED ANSWER
replied on June 1, 2015

I can't quite tell from your screenshot, but it looks like you're looking the token from the Custom Query activity instead of the current iteration in For Each. That token only gives you the first row value.

0 0

Replies

replied on June 1, 2015

What are you using in Modify Tokens?

0 0
replied on June 1, 2015

I am doing 3 different tokens.  For each one I am modifying a token from my original activity "create tokens".  I am using Append to existing value and each value is the column of the database query.

 

0 0
SELECTED ANSWER
replied on June 1, 2015

I can't quite tell from your screenshot, but it looks like you're looking the token from the Custom Query activity instead of the current iteration in For Each. That token only gives you the first row value.

0 0
replied on June 1, 2015

That worked!  Thank you so much.  I changed each token to pull form "for each row" instead of the database query.

 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...