SOQL Query using includes/excludes operator

Question

I am write a query to pull data from a custom object called Interaction Activity. Here is the query I have so far:

SELECT Id, Name, ContactId__c, Call_Type__c FROM Interaction_Activity__c Where Name includes 'INBOUND' AND Call_Type__c = 'OUTBOUND'

This issue I am running into so far, is that Name is not a picklist field and includes/excludes operator only works for picklists. What operator will work for text fields? Contains?

#SOQL Queries

Gudimetla Veera Venkata Satyanarayana · Accepted Answer

@Rachel Barrish try this : SELECT Id, Name, ContactId__c, Call_Type__c FROM Interaction_Activity__c WHERE Name LIKE '%INBOUND%' AND Call_Type__c = 'OUTBOUND'

Heidi Misch · Answer

I know this is an old thread but the NOT CONTAINS was also perplexing me so I figured I'd post here, too. (though this is a different example)  SELECT id,  hed__AlternateEmail__c,hed__UniversityEmail__c FROM Contact where NOT(hed__AlternateEmail__c LIKE '%.invalid' OR hed__UniversityEmail__c LIKE '%.invalid')   I would have thought it was NOT(hed__AlternateEmail__c LIKE '%.invalid') OR NOT(hed__UniversityEmail__c LIKE '%.invalid') but it didn't like the OR operator?

SOQL Query using includes/excludes operator

SOQL Queries

Aprendizagem relacionada

Mais ajuda