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 12.1
edited by Ricardo Julio Rodríguez Fernández
on 2024/03/11 20:15
Change comment: There is no comment for this version
To version 7.1
edited by Ricardo Julio Rodríguez Fernández
on 2024/03/11 19:58
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,6 +1,26 @@
1 1  {{groovy}}
2 2  import groovy.sql.Sql
3 3  def sql = new Sql(services.igfaebbdddummyas.getConnection())
4 -assert sql.firstRow('SELECT * FROM json')
4 +def query = "SELECT
5 + JSON_ARRAYAGG(room_data) AS all_data
6 +FROM (
7 + SELECT
8 + JSON_OBJECT(
9 + 'id', room_id,
10 + 'title', room_title,
11 + 'color', room_color,
12 + 'item', JSON_ARRAYAGG(JSON_OBJECT('title', person))
13 + ) AS room_data
14 + FROM
15 + json
16 + GROUP BY
17 + room_id, room_title, room_color
18 +) AS room_data;"
19 +
20 +println(query.get(0).testid.toString())
21 +
22 +def countitems = appitems.size() println(countitems)
23 +
24 +assert countitems == query.get(0).testid
5 5  sql.close()
6 6  {{/groovy}}