2 Replies Latest reply on May 24, 2019 8:46 AM by Sean Connolly

    Pentaho DI SQL Question

    Sean Connolly
      Share This:

      I'm getting pretty good at creating transformations and jobs in Pentaho.  Unfortunately, I'm not great at SQL .

       

      I have created a Salesforce Input task to pull all open incidents from Remedyforce.  Everything works OK except for my Query Condition where I am trying to specify only open incidents.  I have tried:

      BMCServiceDesk__state__c = Y

      BMCServiceDesk__state__c = 'Y'

      BMCServiceDesk__state__c = "Y"

      BMCServiceDesk__state__c IS 'Y'

      BMCServiceDesk__state__c = "Y"

       

      All of them fail.  Can anyone tell me what the proper syntax is?

       

      Screenshot attached.

       

      Thanks,

      Sean