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

  • alchemiz's avatar
    alchemiz
    2 years ago

    Hi khanh_tran ,

    Good day, you can use the binary properties in the CSV formatter snap

    Hope this helps.




    Thanks,
    EmEm

6 Replies

    • NAl's avatar
      NAl
      Contributor
      4 years ago
      Copy LinkReport

      Hi Spiro,

      Below is the received error message. It doesn’t work either with 2 equal signs…

      Expression parsing failed near -- SSO__c >> = << TRUE (Reason: Attempt to use assignment at line 1:7, which is not supported in the expression language; Resolution: If you meant to compare two values, use two equals signs (==))

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    4 years ago
    Copy LinkReport

    @NAl

    Use ‘=’ instead of ‘==’ on the place where you make comparison .

    Or please share the query that you are trying to execute.

    • NAl's avatar
      NAl
      Contributor
      4 years ago
      Copy LinkReport

      Hi @Spiro_Taleski,

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

      As always thanks for your help