cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Cannot work out correct WHERE CLAUSE Expression

NAl
Contributor

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

1 ACCEPTED SOLUTION

Hi @Spiro_Taleski,

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

As always thanks for your help

View solution in original post

6 REPLIES 6

SpiroTaleski
Valued Contributor

@NAl

Just try with:

CUSTOM_FIELD__c = TRUE

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
Valued Contributor

@NAl

If you have the expression button on, try:

โ€œCUSTOM_FIELD__c = TRUEโ€

image

Nope:
InvalidBatch : Failed to process query: MALFORMED_QUERY: unexpected token: '=='"