Forum Discussion

NAl's avatar
NAl
Contributor
4 years ago
Solved

Cannot work out correct WHERE CLAUSE Expression

I have a Salesforce Read Snap and attempting to write a where clause that is dependent on a boolean field.

This is my current expression:
' CUSTOM_FIELD__c = '+"'" + TRUE + "'"

The error is as follows:
Where Clause: TRUE is undefined. Perhaps you meant: String, Uint8Array

I’ve changed the value from TRUE to 1 but receive this message instead:
must be of type boolean and should not be enclosed in quotes

  • NAl's avatar
    NAl
    4 years ago

    Hi @Spiro_Taleski,

    After attempting lots of variations, this one did the trick:
    'CUSTOM_FIELD__c = TRUE'

    As always thanks for your help