Hey All ,
I am looking to filter user records to only one specific profile name or licensed by in dataflow filter node with SAQL filter check . Here is the screenshot .
"Something went wrong while executing the filter user node: Invalid Filter Expression=Licensed_By__c : EQ : CEC [error category: USER]: Syntax Error at position [line 1: column 17] after token Unexpected character ':' :: ;censed_By__c : EQ : CEC; (02Kj0000000Kys4EAC_03C7i000001vT5TEAU)"
Please help me out if there is anything i need to change or use other filter expression.
You're trying to use "standard" filter syntax in a SAQL filter. Please uncheck the "Use SAQL" or use
'Licensed_By__c' == "CEC"
And a hint: please check if Licensed_By__c holds an ID (it looks like a Lookup field) or the name value. If it's the ID, you have to use the ID in the filter or join the name first to any other field and use this field for your filter.