Commits

Anonymous committed 321c46a Draft

dashboard: fixing problem with sql for postgres as instructed - #132

  • Participants
  • Parent commits 268f9fa

Comments (0)

Files changed (1)

File bhdashboard/widgets/ticket.py

             fieldnm = query.group
             sql, v = query.get_sql() 
             sql = "SELECT COALESCE(%(name)s, '') , count(COALESCE(%(name)s, ''))"\
-                    "FROM (%(sql)s) GROUP BY COALESCE(%(name)s, '')" % \
+                    "FROM (%(sql)s) AS foo GROUP BY COALESCE(%(name)s, '')" % \
                     { 'name' : fieldnm, 'sql' : sql }
             db = self.env.get_db_cnx()
             try :