Changes for page Rooms

Last modified by Ricardo Julio Rodríguez Fernández on 2024/03/13 12:06

From version 29.1

edited by Ricardo Julio Rodríguez Fernández
on 2024/03/12 15:49

Change comment: There is no comment for this version

To version 31.1

edited by Abdullah Sharifi
on 2024/03/12 15:51

Change comment: There is no comment for this version

Summary

Page properties

Author

@@ -1,1 +1,1 @@
--XWiki.RicardoJulioRodriguezFernandez
++XWiki.AbdullahSharifi

Content

@@ -2,7 +2,7 @@
  import groovy.sql.Sql
  def sql = new Sql(services.igfaebbdddummyas.getConnection())
--  sql.eachRow('SELECT * FROM json'){
++  sql.eachRow('SELECT JSON_ARRAYAGG(room_data) AS all_dat FROM (SELECT JSON_OBJECT('id', room_id, 'title', room_title, 'color', room_color, 'item', JSON_ARRAYAGG(JSON_OBJECT('title', person))) AS room_data FROM json GROUP BY room_id, room_title, room_color) AS room_data;'){
              println "${it.room_title}"
          }