Bugfix: Joget Chart Tutorial (MySQL 5.7)

 
1
0
-1

Hi team,

I fixed a bug with the Joget Chart tutorials for people on the newer MySQL 5.7 version.

This version is a lot more strict about "GROUP BY" statements, so all non-aggregated fields need to be added to the group by statement (in this case the lakes of b.name and so on).

Please update the marketplace version with this file (I made no other changes than fixing this bug) - it should work on lower versions of MySQL without issues.

Cheers,

Eric

APP_jtc-1-20170516123046.jwa

UPDATE: I noticed some charts may now display differently - please check to make sure that it still represents the correct view and / or adjust statements accordingly.

    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      Hi Eric

      Thank you for your feedback.

      The Joget Workflow Tutorial App for Charts has been updated with required MySQL GROUP BY columns added as used in SELECT clauses.

      1. Eric

        Thanks Matthew. The datalist tutorial needs to be updated slightly as well (I think only the example with a line with totals). The SQL statement for that datalist should be: select id, c_parameter1 as Infra, c_parameter2 as Description, c_value as DValue, IF(c_parameter3 = "", "", CONCAT("<a href=",c_parameter3," target='_blank'>",c_parameter3,"</a>") ) as Link from app_fd_j_chart_data group by app_fd_j_chart_data.id union ( select MIN(id), "" as Infra, CONCAT("<span style='background-color:#3D9970; color: white; padding:3px 10px;'><b>Total %</b></span>") as Description, CONCAT("<span style='background-color:#3D9970; color: white; padding:3px 10px;'><b>",SUM(c_value), "</b></span>") as DValue, "" as Link from app_fd_j_chart_data ) ---------- I can attach the updated app if you like. Cheers, Eric

      CommentAdd your comment...