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

Question

Question

populate Fields with query data

asked on November 2, 2016 Show version history

I am trying to populate Fields with a query data (DB lookup) in Workflow 9.2.0.167.

I 1st find the entries in a LF folder, for Each Entry, I assign a Template and Filename (which is the entries file name), then I have Retrieve Field Vales for the all the Fields I need populated, then Query Data, I would like it to use the Filename assigned to pull in the rest of the Fields from the DB and then assign those fields.

So far it does find the entries and assigns the template and the file name field, but that's it, it doesn't assign the other fields from the lookup. I do not receive any errors.  I will attach screen shots.  Any advise would be appreciated! Thanks Wendi

WorkFlow.JPG
WF Task.JPG
TestQuery.JPG
assigning fields.JPG
WorkFlow.JPG (127.41 KB)
WF Task.JPG (59.28 KB)
TestQuery.JPG (166.24 KB)
1 0

Answer

SELECTED ANSWER
replied on November 2, 2016

Looking at your external table, the FileName column does have it. So if your value doesn't match exactly, you're not going to get any results in the query. You can add that to the query criteria: %(ForEachEntry_CurrentEntry_Name).TIF

2 0

Replies

replied on November 2, 2016

If I'm reading this correctly, you're trying to get the SSN, DOB and student name from the 3rd party data source?

If that's the case, Retrieve Field Values shouldn't be there. Retrieve Field Values is reading the current values of the fields, which should be blank at this point since Assign Fields is only setting the template and the Filename. Then you're looking up data that matches those (blank) values. So Query Data is not returning anything.

Inside For Each Entry, it should be just Query Data with one condition on the filename, then Assign Fields setting the template and the 4 fields.

1 0
replied on November 2, 2016

Did you try looking at the instance details to see if there are any errors or warnings?

If I had to guess, your Query Data is not returning anything because it's set to match on %(Entry Name). That's the name of the starting entry and this workflow most likely doesn't have one. You want to match on the current entry's name in the For Each loop, so the criterion in Query Data should be something like %(ForEachEntry_CurrentEntry_Name).

1 0
replied on November 2, 2016

yes that is what I changed it to and republished.   I don't receive any errors. The template does get assigned but no Fields get populated.

queydata foreachentry.JPG
lf doc.JPG
lf doc.JPG (98.83 KB)
1 0
replied on November 2, 2016

it says it's executing, but no other error and nothing happens?  Like it's not talking to the table? It's a small table and I don't get errors when I test and I can see the columns? Any thoughts? Thanks Wendi

task.JPG
task.JPG (62.6 KB)
1 0
replied on November 2, 2016

It seems to be setup in the Admin console ok, and like I said there are no errors in my workflow.

externalTables.JPG
1 0
replied on November 2, 2016

Ok it looks like it just keeps running assign Field values, but nothing get assigned?

assignFieldValues.JPG
1 0
replied on November 2, 2016

Do you have the .TIF extension in the document name in Laserfiche?

0 0
replied on November 2, 2016

no

0 0
replied on November 2, 2016

should I?

0 0
SELECTED ANSWER
replied on November 2, 2016

Looking at your external table, the FileName column does have it. So if your value doesn't match exactly, you're not going to get any results in the query. You can add that to the query criteria: %(ForEachEntry_CurrentEntry_Name).TIF

2 0
replied on November 3, 2016

Thank You Miruna!!!!  That did the trick! You are the best!!

1 0
replied on November 2, 2016

Hi Miruna, thank you so much for your reply.   I made the change, but must be missing something. Now only the template gets assigned and no fields, not even the name gets populated.  Please advise on what I am missing. Screen shots included.  Thanks Wendi

assign fields.JPG
querydata.JPG
assign fields.JPG (144.08 KB)
querydata.JPG (149.92 KB)
0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.