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 41.1
edited by Abdullah Sharifi
on 2024/03/12 16:15
Change comment: There is no comment for this version
To version 30.1
edited by Abdullah Sharifi
on 2024/03/12 15:50
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,14 +3,24 @@
1 -
2 -
3 3  {{groovy}}
4 4  import groovy.sql.Sql
5 5  def sql = new Sql(services.igfaebbdddummyas.getConnection())
6 6  
7 -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 aggregated_data") { row ->
8 - println(row.all_data)
9 -}
5 + sql.eachRow('SELECT
6 + JSON_ARRAYAGG(room_data) AS all_data
7 +FROM (
8 + SELECT
9 + JSON_OBJECT(
10 + 'id', room_id,
11 + 'title', room_title,
12 + 'color', room_color,
13 + 'item', JSON_ARRAYAGG(JSON_OBJECT('title', person))
14 + ) AS room_data
15 + FROM
16 + json
17 + GROUP BY
18 + room_id, room_title, room_color
19 +) AS room_data;'){
20 + println "${it.room_title}"
21 + }
10 10  
11 11  sql.close()
12 12  {{/groovy}}
13 -
14 -