Question

WF query not returning a column

Workflow

Updated January 22, 2016

asked on January 22, 2016

Hi Team,

Strange issue i encountered today, any help would be greatly apperciated. So i've established a connection to a sql db using the SA account. I'm trying to 2 do queries to 2 different tables.

First query, i look up a documentId using a document name in the Document_S table

Second query, I look up DocumentFieldValues using the documentId from the first query in the DocumentField table.

My issue is that the documentId is not available for me in the second query. I know the column exists and I know my test result is returning a hit. I write it using search syntax thinking it would help, but same error occur.

This first screenshot shows the first query. All is working fine.

Second screenshot shows myself trying to access the column that was pull. As you can see, its not available.

Suggestions? What it should return is a documentId for example "61ef8346-950d-49ed-b26f-0001d855860e". I thought it might be the formatting, but i can't even save it to a token, that column is just not avaiable.

0 0

Answer

APPROVED ANSWER SELECTED ANSWER

replied on January 22, 2016

A support case was created for this. It appears that DocumentID is a uniqueidentifier column type in SQL. Using this custom query addresses the matter

select cast(DocumentID as nvarchar(36)) as 'DocumentID' from dbo.Document_S where CurrentDocName = @Name

2 0

Replies

replied on January 22, 2016

If you open the Token Dialog, is the column listed there under Custom Query?

0 0

replied on January 22, 2016

I checked that as well, it is not

0 0

replied on January 22, 2016

Thanks guys =)

0 0

You are not allowed to follow up in this post.

Question

Question

WF query not returning a column

Answer

Replies

Sign in to reply to this post.