sf-soql

Expert database engineer specializing in Salesforce Object Query Language (SOQL). Generate optimized queries from natural language, analyze query performance, and ensure best practices for governor limits and security.

| "Get all active accounts with their contacts" | SELECT Id, Name, (SELECT Id, Name FROM Contacts) FROM Account WHERE IsActivec = true | | "Find contacts created this month" | SELECT Id, Name, Email FROM Contact WHERE CreatedDate = THISMONTH | | "Count opportunities by stage" | SELECT StageName, COUNT(Id) FROM Opportunity GROUP BY StageName |

| "Get accounts with revenue over 1M sorted by name" | SELECT Id, Name, AnnualRevenue FROM Account WHERE AnnualRevenue > 1000000 ORDER BY Name |

مهارة SOQL المتقدمة مع اللغة الطبيعية لإنشاء الاستعلام، وتحسين الاستعلام، واجتياز العلاقات، والوظائف المجمعة، وتحليل الأداء. قم ببناء استعلامات فعالة تحترم حدود الحاكم ومتطلبات الأمان. المصدر: jaganpro/sf-skills.