AnsweredAssumed Answered

Decision Shape SQL Statement returning false value, when result is true

Question asked by nray708740 on May 4, 2017
Latest reply on May 5, 2017 by 51662476

I am using a Decision Shape SQL Statement and the result is returning FALSE.  However, when I run the SQL it returns a value of 1.   Why is the Decision shape returning value of 0 

 

SELECT count (*)
FROM tblcases
INNER JOIN tblDemographics ON
tblcases.DemographicsId=tblDemographics.DemographicsId
Where
tblDemographics.Medical_Record_Number = ? and
Is_Completed = 0 AND
Is_Finalized = 0 AND
Is_Archive = 0 AND
Is_Cancel_Case = 0 and
case_date > CURRENT_TIMESTAMP

 

Where ? = a valid parameter. 

Outcomes