11-26-2021 04:39 AM
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
Solved! Go to Solution.
11-29-2021 02:22 AM
Hi @Spiro_Taleski,
After attempting lots of variations, this one did the trick:
'CUSTOM_FIELD__c = TRUE'
As always thanks for your help
11-26-2021 01:35 PM
Use ‘=’ instead of ‘==’ on the place where you make comparison .
Or please share the query that you are trying to execute.
11-29-2021 02:22 AM
Hi @Spiro_Taleski,
After attempting lots of variations, this one did the trick:
'CUSTOM_FIELD__c = TRUE'
As always thanks for your help