Loading...
Loading...
Compare original and translation side by side
platform-soql-query.soqlplatform-soql-query.soql| Need | Default pattern |
|---|---|
| parent data from child | child-to-parent traversal |
| child rows from parent | subquery |
| counts / rollups | aggregate query |
| records with / without related rows | semi-join / anti-join |
| text search across objects | SOSL |
| 需求 | 默认模式 |
|---|---|
| 从子对象获取父对象数据 | 子对象到父对象的遍历 |
| 从父对象获取子对象行数据 | 子查询 |
| 计数/汇总 | 聚合查询 |
| 存在/不存在关联行的记录 | 半连接/反连接 |
| 跨对象文本搜索 | SOSL |
SELECT *SELECT *references/soql-syntax-reference.mdQuery goal: <summary>
Query: <soql or sosl>
Design: <relationship / aggregate / filter choices>
Notes: <selectivity, limits, security, governor awareness>
Next step: <run in platform-data-manage or embed in Apex>references/soql-syntax-reference.mdQuery goal: <摘要>
Query: <soql或sosl>
Design: <关联/聚合/筛选选择说明>
Notes: <选择性、限制、安全、Governor限制相关说明>
Next step: <在platform-data-manage中运行或嵌入到Apex>| Need | Delegate to | Reason |
|---|---|---|
| run the query against an org | platform-data-manage | execution and export |
| embed the query in services/selectors | platform-apex-generate | implementation context |
| analyze slow-query symptoms from logs | platform-apex-logs-debug | runtime evidence |
| wire query-backed UI | experience-lwc-generate | frontend integration |
| 需求 | 转交至 | 原因 |
|---|---|---|
| 在组织中运行查询 | platform-data-manage | 执行与导出 |
| 在服务/选择器中嵌入查询 | platform-apex-generate | 实现上下文 |
| 从日志分析慢查询症状 | platform-apex-logs-debug | 运行时证据 |
| 构建基于查询的UI | experience-lwc-generate | 前端集成 |
| Score | Meaning |
|---|---|
| 90+ | production-optimized query |
| 80–89 | good query with minor improvements possible |
| 70–79 | functional but performance concerns remain |
| < 70 | needs revision before production use |
| 分数 | 含义 |
|---|---|
| 90+ | 生产级优化查询 |
| 80–89 | 良好查询,可进行小幅改进 |
| 70–79 | 功能可用,但仍存在性能问题 |
| < 70 | 需修订后才能用于生产环境 |
| File | When to read |
|---|---|
| Syntax, operators, date literals, relationship query patterns |
| Selectivity rules, indexing strategy, governor limits, security patterns |
| Quick reference — operators, date functions, aggregate functions, WITH clauses |
| Common SOQL mistakes and their fixes — read before finalizing any query |
| Apex selector layer patterns — read when embedding queries in Apex classes |
| Field coverage validation — read when generating SOQL used inside Apex code |
| sf CLI query execution, bulk export, query plan commands |
| Starter query examples for common objects |
| Parent-to-child and child-to-parent relationship query patterns |
| COUNT, SUM, GROUP BY, ROLLUP query patterns |
| Selective filter and index-aware query patterns |
| Apex Map-based bulk query pattern for trigger contexts |
| Full selector class implementation template |
| Post-write hook — runs static SOQL validation and live query plan analysis after |
| 文件 | 阅读场景 |
|---|---|
| 语法、运算符、日期字面量、关联查询模式 |
| 选择性规则、索引策略、Governor限制、安全模式 |
| 快速参考——运算符、日期函数、聚合函数、WITH子句 |
| 常见SOQL错误及修复方案——在最终确定任何查询前阅读 |
| Apex选择器层模式——在Apex类中嵌入查询时阅读 |
| 字段覆盖验证——在生成用于Apex代码的SOQL时阅读 |
| sf CLI查询执行、批量导出、查询计划命令 |
| 常见对象的入门查询示例 |
| 父对象到子对象及子对象到父对象的关联查询模式 |
| COUNT、SUM、GROUP BY、ROLLUP查询模式 |
| 选择性筛选及索引感知查询模式 |
| 用于触发器上下文的基于Apex Map的批量查询模式 |
| 完整的选择器类实现模板 |
| 写入后钩子——在编辑.soql文件后运行静态SOQL验证和实时查询计划分析 |