我使用rails ransack(https://github.com/ernie/ransack)来允许用户过滤和排序一些记录.我用传统的方法得到经过过滤和排序的记录.
@invoices = Invoice.search(params[:q]).result
现在我想得到一些概要信息
@invoices = Invoice.search(params[:q]).result
@summary = @invoices.select("sum(balance) as balance_total").first
除非用户指定要排序的字段.我得到了SQL错误:
Column "project_name" is invalid in the ORDER BY clause because
it is not contained in either an aggregate function or the GROUP BY clause
我可以从范围中删除排序吗?怎样
谢谢