I have a SQL query that is always returning true for my boolean field even though the data in SF is showing false. Incomplete_Runtime_Data__c is the boolean field, all other fields return correctly.
Select d.WelcomeEmailAddress__c as [EmailAddress], d.Id as [DeviceId], d.Name as [DeviceName], p.Name as [ProductName], c.FirstName as [FirstName], d.ContactID__c as [ContactID], r.Id as [RuntimeID], r.Online__c as [Online], r.Date__c as [Date], r.Incomplete_Runtime_Data__c as [Incomplete_Runtime_Data] From Runtime__c_Salesforce r with(nolock) Left Join Device__c_Salesforce d with(nolock) on r.Device__c = d.id Left Join Product2_Salesforce p with(nolock) on d.Product__c = p.id Left Join Contact_Salesforce c with(nolock) on d.ContactID__c = c.Id
In the Data Extension, I have the field Incomplete_Runtime_Data marked as boolean and nullable.
Why would the data only show True when it should be False?