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 04:46 AM
11-26-2021 05:00 AM
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 (==))
11-26-2021 05:08 AM
11-26-2021 08:18 AM
Nope:
InvalidBatch : Failed to process query: MALFORMED_QUERY: unexpected token: '=='"