Timeline for SOQL exclude records with blank values on Multi-select picklist fields
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 6, 2015 at 5:45 | comment | added | C0DEPirate | Thank you @crmprogdev. Working fine with your solution : Select Id, Name,Application_type__c , Lead_Age_Days__c from Lead where isConverted = false and ( (LeadSource = 'Client-Portal-Lead' and Client_Portal_Stage__c = 'Page2 Completed') or (LeadSource = 'Client-Portal-Lead-Ar' and Client_Portal_Stage__c = 'Page2 Completed') or (LeadSource = 'Manual entry' and Client_Portal_Stage__c = null) ) and Entity__c = 'Abu Dhabi' and CST_Owner__c = null and Application_type__c excludes ('No application','Global Markets') and Application_type__c !='' ORDER BY CreatedDate ASC | |
| Nov 6, 2015 at 5:41 | vote | accept | C0DEPirate | ||
| Nov 5, 2015 at 16:00 | history | answered | crmprogdev | CC BY-SA 3.0 |