请问使用 GROUP BY HAVING 时，如何设置 SUM 内部表达式？

[shuqingzai]

Your Question

参考: Group By & Having

使用 group by Having Sum 表达时，怎么设置 sum 的条件

o.WithContext(ctx).Select(o.CreateAt.Date().As("date"), o.WithContext(ctx).Amount.Sum().As("total")).Group(o.CreateAt.Date()).Having(u.Amount.Sum().Gt(100)).Scan(&results)

上述语句提取 GroupBY HAVING 部分类似

... GROUP BY `order`.`create_at` HAVING SUM(`user`.`amount`) > 100

The document you expected this should be explained

Expected answer

我期望可以实现在 SUM 计算字段匹配值

... GROUP BY `order`.`create_at` HAVING SUM(`user`.`amount` > 10) > 100

根据

gen/field/int.go

Line 141 in 5360707

func (field Int) Sum() Int {

我似乎没法传递表达式修改 SUM 的条件

[mimicode]

#1213