Hello! As the title states, I have a field that contains multiple strings that correspond to Salesforce UserNames. When trying to check if a UserName is contained in this field, I get the following error:
1. An error occurred while attempting to perform the following SOQL query: SELECT Comments__c,Level_1__c,Level_2__c,Level_3__c,Recommendation__c,TBA_Selection__c,TBA_Selection__r.Name,Tags__c,Value__c,Score_Type__c,Id FROM TBA_Score__c WHERE (Level_1__c = 'TLS')AND(Level_2__c = 'Vision: They dream big')AND(Level_3__c = 'Create a powerful vision')AND(Score_Type__c = 'Written Assessment')AND(TBA_Selection__c = 'a2A800000007tOeEAI')AND(Question__c = '1')AND(Tags__c = 'Written#, Q1#')AND(TBA_Selection__r.X2nd_Reviewer__c includes 'Eulogio Gallo') LIMIT 2 Error:expecting a left parentheses, found 'Eulogio Gallo'
It appears that Skuid isn’t formatting the resulting SOQL query properly, forgetting the parentheses needed for the ‘includes’ keyword in the SOQL query. Not sure how to remedy this, but any advice would be appreciated. Thanks!