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

Question

Question

Workflow sequential read from an external db

asked on November 13, 2014

HI, how can I read (sequentially) from an external DB to retrive a field value (total of 20K rows) and search within LF for the retrived value and  assign a tag to the entries found?

0 0

Replies

replied on November 13, 2014 Show version history

What do you mean sequentially? 

 

Use a "Custom Query" Activity with the query and have it "ORDER BY " the criteria you want. You then can use a "For Each Row" activity to loop through the results in the order they were returned to the workflow. Put your search and tag assignment activities inside the "For Each Row" activity and you will have your intended goal

 

EDIT:

 

Once you have the Custom query and the "For Each Row" Activity configured, you will have your Search obviously. But following the search, you need to use a "For Each Entry" Activity to assign the tags since you want to tag however many results come up from the search, and not just the first one. 

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

Sign in to reply to this post.