I created a query rule in which I am going up against a database and checking to

I created a query rule in which I am going up against a database and checking to see if a value is null. The column in question is called COP_NUM. In the attached screenshot, the column is populated with "NULL". When I use the following SQL statement outside of Appian, I get back the correct rows:
select * from ppe_reports.dbo.cop_automation
where cop_Num IS NULL

My query rule uses the condition COP_NUM=COP_NUMValue. I do not know what value to pass to COP_NumValue in a query expression to make the query work. I tried entering nothing, then "", and then '' but with no sucess. Can anyone help? Thank you. ...

OriginalPostID-109907

OriginalPostID-109907

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data