Question

Custom Query result tokens not available in Workflow Designer

Workflow Version 8

Updated July 21, 2015

asked on July 21, 2015

I'm using Workflow 8.3.

I've created a Data Source that links to an Oracle instance - OracleOdbc(Direct).

I created a Custom Query that uses the Data Source - the query is a straight forward select from a view - it uses two parameters and returns one record. The query tests as expected - successful with "1 row(s) affected".

But when I try to create another activity - "Branch", "Track Tokens", or "Assign Field Values" - that would use the results of my custom query, the only token that Workflow Designer offers is the "Results Found" token.

How can I include the results of my custom query in activities that follow?

1 0

Replies

replied on July 21, 2015

Brett,

Can you post your query? Are you defining the columns for return in your select statement?

0 0

replied on July 21, 2015

My query...

I'm not sure what you mean by "defining the columns for return." Did I cover it above?

0 0

replied on July 21, 2015

Maybe I setup a circular reference in my parameters. This seems better...

...but when I test it, I was manually entering values. So I think this was not part of my immediate problem.

0 0

replied on July 21, 2015

This is expected behavior. You need to iterate through your results with For Each Row.

0 0

replied on July 21, 2015

That gives me access to the tokens and - once included in a task - the workflow validates successfully. Looks like it's going to work.

Thanks

I didn't expect to have to use For Each Row when I only had one row, but so long as it works...

0 0

You are not allowed to follow up in this post.

Question

Question

Custom Query result tokens not available in Workflow Designer

Replies

Sign in to reply to this post.