Changes for page Rooms

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

From version 30.1

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

Change comment: There is no comment for this version

To version 28.5

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

Change comment: Added comment

Summary

Page properties

Author

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

Content

@@ -2,21 +2,7 @@
  import groovy.sql.Sql
  def sql = new Sql(services.igfaebbdddummyas.getConnection())
--  sql.eachRow('SELECT
--    JSON_ARRAYAGG(room_data) AS all_data
--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;'){
++  sql.eachRow('SELECT * FROM json'){
              println "${it.room_title}"
          }