liquid_feedback_frontend
changeset 270:08a5e1226da2
Fixed error when issue population is zero
author | bsw |
---|---|
date | Tue Feb 07 20:03:31 2012 +0100 (2012-02-07) |
parents | 55c2806c7113 |
children | d13b27a37ad5 |
files | app/main/initiative/_list.lua |
line diff
1.1 --- a/app/main/initiative/_list.lua Tue Feb 07 19:59:24 2012 +0100 1.2 +++ b/app/main/initiative/_list.lua Tue Feb 07 20:03:31 2012 +0100 1.3 @@ -122,7 +122,7 @@ 1.4 order_filter[#order_filter+1] = { 1.5 name = "potential_support", 1.6 label = _"Potential support", 1.7 - selector_modifier = function(selector) selector:add_order_by("initiative.supporter_count::float / issue.population::float DESC, initiative.id") end 1.8 + selector_modifier = function(selector) selector:add_order_by("CASE WHEN issue.population = 0 THEN 0 ELSE initiative.supporter_count::float / issue.population::float END DESC, initiative.id") end 1.9 } 1.10 1.11 order_filter[#order_filter+1] = {