diff options
Diffstat (limited to 'addons/idea/idea.py')
| -rw-r--r-- | addons/idea/idea.py | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/addons/idea/idea.py b/addons/idea/idea.py index 20a2904c4e6..dd0a22cf523 100644 --- a/addons/idea/idea.py +++ b/addons/idea/idea.py @@ -68,11 +68,11 @@ class idea_idea(osv.osv): sql = """SELECT i.id, avg(v.score::integer) FROM idea_idea i LEFT OUTER JOIN idea_vote v ON i.id = v.idea_id - WHERE i.id = ANY(%s) + WHERE i.id IN %s GROUP BY i.id """ - cr.execute(sql, (ids,)) + cr.execute(sql, (tuple(ids),)) return dict(cr.fetchall()) def _vote_count(self, cr, uid, ids, name, arg, context=None): @@ -88,11 +88,11 @@ class idea_idea(osv.osv): sql = """SELECT i.id, COUNT(1) FROM idea_idea i LEFT OUTER JOIN idea_vote v ON i.id = v.idea_id - WHERE i.id = ANY(%s) + WHERE i.id IN %s GROUP BY i.id """ - cr.execute(sql, (ids,)) + cr.execute(sql, (tuple(ids),)) return dict(cr.fetchall()) def _comment_count(self, cr, uid, ids, name, arg, context=None): @@ -108,11 +108,11 @@ class idea_idea(osv.osv): sql = """SELECT i.id, COUNT(1) FROM idea_idea i LEFT OUTER JOIN idea_comment c ON i.id = c.idea_id - WHERE i.id = ANY(%s) + WHERE i.id IN %s GROUP BY i.id """ - cr.execute(sql, (ids,)) + cr.execute(sql, (tuple(ids),)) return dict(cr.fetchall()) def _vote_read(self, cr, uid, ids, name, arg, context = None): |