case-soql-field-paths-for-crm-count-queries

Verified Production org field paths for Case-to-Opportunity cross-object SOQL: Opportunity__r.StageName for stage, Key_Handover_Date__c (date field directly on Case, not on Opportunity), Origin for channel source (excludes channel partner via NOT Origin LIKE ‘%Channel Partner%’), Owner.Name for owner name string comparison. These were confirmed against live schema describe output.

Related

• aj-ea-core-mcp-servers-permanently-registered
• gws-capability-expansion-nova (archived)
• nova-critical-learnings-consolidated
• enterprise-capability-expansion-5-pillars-from-digital-employee-analysis
• salesforce-apex-code-deployment-pattern-sf-write-apex-class
• key-handover-date-aging-90-days-means-historical-not-future
• case-key-handover-date-field-location-and-semantics
• crm-case-count-validated-soql-unit-booked-baseline
• salesforce-case-key-handover-date-directly-on-case-object
• salesforce-mcp-org-configs-stores-type-not-alias
• salesforce-report-creation-workflow-column-identifier-format
• soql-entitydefinition-does-not-support-or-operator