Kanban - rounding summary field

[norber...@multimageweb.com]

hi Diego,

i would like rounding summary field SQL, but when rounding added, then sql error generated, and summary pane hidden.

WORKS

@SQL=SELECT SUM(Weight) || ' Kg' AS Weight FROM M_InOut WHERE C_ShippingRegion_ID = @KanbanStatus@

DOESNT WORKS

@SQL=SELECT ROUND(SUM(Weight),0) || ' Kg' AS Weight FROM M_InOut WHERE C_ShippingRegion_ID = @KanbanStatus@

ERROR LOG

-------------------------------

19:10:47.991===========> MKanbanStatus.getSummary: SELECT ROUND(SUM(Weight),2) as Weight FROM M_InOut WHERE C_ShippingRegion_ID = '1000072' AND M_InOut.AD_Client_ID IN (0, ?) AND M_InOut.IsActive='Y'  [31]

org.postgresql.util.PSQLException: The column index is out of range: 2, number of columns: 1.; State=22023; ErrorCode=0

    at org.postgresql.jdbc.PgResultSet.checkColumnIndex(PgResultSet.java:2751)

     at org.postgresql.jdbc.PgResultSet.checkResultSet(PgResultSet.java:2771)

       at org.postgresql.jdbc.PgResultSet.getString(PgResultSet.java:1894)

    at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:4865)

   at org.kanbanboard.model.MKanbanStatus.getSummary(MKanbanStatus.java:267)

      at org.idempiere.webui.apps.form.WKanbanBoard.createKanbanBoardPanel(WKanbanBoard.java:348)

    at org.idempiere.webui.apps.form.WKanbanBoard.repaintGrid(WKanbanBoard.java:849)

       at org.idempiere.webui.apps.form.WKanbanBoard.onEvent(WKanbanBoard.java:685)

   at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2773)

      at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2744)

      at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2685)

      at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)

at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1765)

      at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1550)

   at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1260)

at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:611)

at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:485)

  at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:494)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)

norbert

[Chill]

Hi,

I had once similar issue, changing as follow fixed it:

SELECT SUM(ROUND(Weight,2))

Don't ask why...but it worked.

Regards