You need to sign in to do that
Don't have an account?
cl0s3r
SOQL Fu, Where are the ninjas
I have a conundrum. I want to run a query using the Like Comparison on multiple elements, but not having much luck. When I attempt to us "Or" logic within a "Like" comparison no records are returned. Can someone assist?
SELECT Academic_Plan_Returned__c, Campus_Name__c, CreatedById, CreatedDate, Quarter__c, Student__r.Name, Student__r.Student_Id__c FROM At_Risk__c where Student__r.Student_Id__c != '9999' and Academic_Plan_Returned__c = true and CreatedDate > 2013-04-05T00:00:00Z and CreatedDate < 2013-05-19T00:00:00Z and Campus_Name__c like '%new port,tampa%'
Jake Gmerek
SELECT Academic_Plan_Returned__c, Campus_Name__c, CreatedById, CreatedDate, Quarter__c, Student__r.Name, Student__r.Student_Id__c FROM At_Risk__c where Student__r.Student_Id__c != '9999' and Academic_Plan_Returned__c = true and CreatedDate > 2013-04-05T00:00:00Z and CreatedDate < 2013-05-19T00:00:00Z and (Campus_Name__c like '%new port%' or Campus_Name__c like '%tampa%')