Core Data如何获取计算值并按关联字段分组求计算值总和？

错误原因 #

Core Data的SQLite存储后端对聚合函数的参数有严格限制，你之前通过嵌套NSExpression(forFunction:)构造的复合运算表达式无法被识别为合法的聚合参数，仅支持直接键路径、常量，或者通过格式化字符串构造的复合运算表达式。

正确实现 #

直接通过表达式格式化字符串构造聚合逻辑，运算会直接下推到SQLite层执行，无需加载全量数据到内存：

let valueRequest = NSFetchRequest<NSDictionary>(entityName: RowMO.entityName)
valueRequest.resultType = .dictionaryResultType

// 构造包含全部运算逻辑的sum聚合表达式
let sumExpression = NSExpression(format: "sum:((price1 + price2) * quantity)")
let sumDescription = NSExpressionDescription()
sumDescription.expression = sumExpression
sumDescription.name = "sum"
sumDescription.expressionResultType = .doubleAttributeType

valueRequest.propertiesToFetch = [#keyPath(RowMO.file.name), sumDescription]
valueRequest.propertiesToGroupBy = [#keyPath(RowMO.file.name)]

// 执行查询
do {
    let groupResults = try persistentContainer.viewContext.fetch(valueRequest)
    groupResults.forEach { dict in
        guard let groupName = dict[#keyPath(RowMO.file.name)] as? String,
              let totalValue = dict["sum"] as? Double else { return }
        // 处理分组结果
        print("分组\(groupName)的总计算值: \(totalValue)")
    }
} catch {
    print("分组统计失败: \(error)")
}

可选优化 #

如果你的price1、price2、quantity属性是可选类型，建议用COALESCE处理空值，避免空值导致计算结果异常：

let sumExpression = NSExpression(format: "sum:((COALESCE(price1, 0) + COALESCE(price2, 0)) * COALESCE(quantity, 0))")

内容的提问来源于stack exchange，提问作者ACl