fuller
Nintex Newbie

Workflow SQL ISNULL Query Results

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.

inline sql.PNG

sql nintex.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. 

Actual wf.PNG

 

Thanks in advance. 

0 Kudos
Reply