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

Question

Question

custom query not pulling data from first column but does for the rest.

asked on July 13, 2022 Show version history

I have data in a SQL view as such:

My  goal is just to pull the whole role row and store the data in a token. 

Here is my custom query that I am testing: 

SELECT * FROM [CFR].[contacts].[members] WHERE [Last Name]='Bamberger'

When I see what info is in the tokens, the part I redacted above doesn't show up below in "id". Why would the workflow only pull part of the data? The only thing I can think of is that there is a space on the column name, but the column of Bamberger is "Last Name", so that doesn't seem like that could be it. 

0 0

Replies

replied on July 13, 2022

I do not know why, but for some reason with the View not in the dbo schema was causing an issue with a Case statement in the view and returning blank data for that value.  Recreating the view with the dbo schema resolved the issue.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.