Hi
I want to sort by an calculation on an associated table, i.E.
config.columns[:findings].includes = [ :vulnerabilities ]
config.columns[:findings].sort_by :sql => 'sum(vulnerabilities.score)'
This doesn't work as AS don't set the necessary "group by"-clause:
ActionView::Template::Error (PG::GroupingError: ERROR: column
"tbl_node.node_id" must appear in the GROUP BY clause or be used in an
aggregate function
LINE 1: SELECT DISTINCT "tbl_node"."node_id", sum(vulnerabilities.s...
^
: SELECT DISTINCT "tbl_node"."node_id", sum(vulnerabilities.score) AS
alias_0, "tbl_node"."node_id" AS alias_1 FROM "tbl_node" LEFT OUTER JOIN
"findings" ON "findings"."system_id" = "tbl_node"."node_id" AND
(findingstate_id != 4) LEFT OUTER JOIN "vulnerabilities" ON
"vulnerabilities"."id" = "findings"."vulnerability_id" WHERE ('t'='t')
ORDER BY sum(vulnerabilities.score) ASC, "tbl_node"."node_id" ASC LIMIT $1
OFFSET $2):
Is there any possibility to tell AS to set this clause?
Thanks, Jan
--
You received this message because you are subscribed to the Google Groups
"ActiveScaffold : Ruby on Rails Gem" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/activescaffold.
For more options, visit https://groups.google.com/d/optout.
