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 a...
  • 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

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