Question

Only 1 field is being retrieved and saved into SQL

Workflow

Updated August 15, 2023

asked on February 23, 2016 • Show version history

I am trying to save my metadata to a seperate SQL table. However, I consistently only get one field to populate data. The Employee Number data is found and saved into SQL. Nothing else. I change the job from 12 fields to 2 for testing. And I only get that one field.

Why would Retrieve Field Values only get values from one field?

0 0

Replies

replied on February 23, 2016

If you have more than one value within a multi value field, then you must use "For Each Value" activity within workflow.

0 0

replied on February 24, 2016

If I understand your reply, each field only contains a single value. And to test out my theory, I changed the Retrieve Field Values to retrieve a different field that contains a single value. And it still does not display a value in the token field after I run the workflow.

The only field that has EVER displayed a token value and hence saved that value into SQL is the EmpID field. And I am clueless as to why.

0 0

replied on February 24, 2016

Can you show what your workflow looks like? Also where are you getting the information from that you are trying to use(forms, scanned document)?

0 0

replied on February 24, 2016

Good morning. Here is my workflow.

Forms is configured to save documents to a specified folder in my repository. However, even if I create a document via Laserfiche client manually, I still get the same results. Namely, only the EmpID field is read.

0 0

replied on February 24, 2016 • Show version history

I have a few workflows that update SQL tables instead of the 'Insert Data' tool. I always use the 'Custom Query' Workflow tool. With the 'Custom Query' tool you can write your own query. For instance you could use

UPDATE dbo.workplease

SET EmpID ='use the token value here', WO='other token value here'

if you are updating information, or you can use an insert statement if you are simply inserting info into the database

INSERT INTO dbo.workplease

VALUES ('EmpID token here', 'WO token here')

0 0

replied on February 24, 2016

At this point, the tables get updated when there is data to update. My issue seems to be the Retrieve Field values is not retrieving....

0 0

replied on February 24, 2016

Can you add a screenshot of the properties of Retrieve Field Values activity?

0 0

replied on February 24, 2016

The problem has been fixed. And I am embarrassed to tell what I was missing. The rule was not setup correctly....

Thank you all for your fast responses!

0 0

replied on August 15, 2023

It would be helpful if you could mention the piece that was missing. I am having the same issue in a Cloud workflow, and it's really puzzling.

0 0

You are not allowed to follow up in this post.

Question

Question

Only 1 field is being retrieved and saved into SQL

Replies

Sign in to reply to this post.