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

Question

Custom query return does not update fields even though test query worked

Workflow

Updated April 30, 2020

asked on April 29, 2020

I made a custom query against a SQL server view. The test of the query says one record found which is correct. I run the query in Workflow and write back the results to field in a template. The Workflow writes back that records found as true and results count as 1, but will not write the values of column results into the fields that have been mapped.

This is a query against a SQLServer View as opposed to a table if that matters.

0 0

Replies

replied on April 29, 2020

What message is given by the workflow that is trying to write the values to the metadata fields? A screenshot of the workflow and any errors would be helpful :)

Jonathan

1 0

replied on April 30, 2020

That's the problem. No errors. I created fields to write the "results found" and "results count" and it writes to those templates fields, True and 1 respectively as if it ran.

0 0

replied on April 30, 2020

I manged to get an error. This is query a view based on a linked server data source on a 32bit sql server.

0 0

replied on April 30, 2020

Do you have a "Track Tokens" added to the end of your workflow? If not, add it. It may give you an idea of what values are being retrieved for each token value.

Question

Question

Custom query return does not update fields even though test query worked

Replies

Sign in to reply to this post.