crm-case-count-validated-soql-unit-booked-baseline

Validated SOQL for Runwal CRM case counts: Opportunity__r.StageName = ‘Unit Booked’ AND (NOT Origin LIKE ‘%Channel Partner%’) AND Owner.Name != ‘Arun Kumar T’. The Origin exclusion pattern catches both ‘Email - Channel Partner’ and ‘Channel Partner Portal’ variants with a single LIKE. Baseline with conditions 1-3 only: 222,576 cases. With KHD aging > 90 days: 99,993. With KHD < 90 days or blank: 122,583.

Related

• case-soql-field-paths-for-crm-count-queries
• salesforce
• case-key-handover-date-field-location-and-semantics
• key-handover-date-aging-90-days-means-historical-not-future
• salesforce-apex-code-deployment-pattern-sf-write-apex-class
• salesforce-case-key-handover-date-directly-on-case-object
• soql-entitydefinition-does-not-support-or-operator