Workflow SQL ISNULL Query Results

  • 24 March 2021
  • 0 replies
  • 21 views

Badge +1

I have a 2019 on prem workflow query against a data warehouse that appears to provide different results when the workflow runs as opposed to the 'run now' option within the workflow editor and the results when I execute the query in SQL. 

 

Originally I was getting a DBNull error which I figured I could resolve with an IFNULL statement, but when the workflow executes the action it seems to be replacing a non null value with the blank value I am trying to replace potential null values with. 

 

I am not a SQL guru, I barely get by with the help of Google, so perhaps this is just a misunderstanding of what I am trying to accomplish, which is to query the data warehouse and replace a NULL Received Date value with another value as to avoid the DBNull workflow error. 

 

Here is the workflow SQL query which pulls back a result that matches the data warehouse; 1/8/2019.

10630iD2C39E273A7780AE.png

10631iD4412292A82F0C9A.png

But when the workflow executes, it appears to replace the value with the ' ' value even though the value in the data warehouse is not null. I've tried both a txt and dat variable to store the data. 

10632iBBEF408BA6075B61.png

 

Thanks in advance. 


0 replies

Be the first to reply!

Reply