Skip to Content

Team

Summer Fellowships

Changes for page Rooms

Last modified by Ricardo Julio Rodríguez Fernández on 2024/03/13 12:06
From version 31.1
edited by Abdullah Sharifi
on 2024/03/12 15:51
Change comment: There is no comment for this version
To version 34.1
edited by Abdullah Sharifi
on 2024/03/12 16:03
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -2,9 +2,7 @@
2 2  import groovy.sql.Sql
3 3  def sql = new Sql(services.igfaebbdddummyas.getConnection())
4 4  
5 - 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;'){
6 - println "${it.room_title}"
7 - }
5 + 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;')
8 8  
9 9  sql.close()
10 10  {{/groovy}}