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 38.1
edited by Abdullah Sharifi
on 2024/03/12 16:06
Change comment: There is no comment for this version
To version 28.2
edited by Ricardo Julio Rodríguez Fernández
on 2024/03/12 09:39
Change comment: Added comment

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.AbdullahSharifi
1 +XWiki.RicardoJulioRodriguezFernandez
Content
... ... @@ -1,13 +3,10 @@
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, 'items', 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 * FROM json'){
6 + println "${it.room_title}"
7 + }
10 10  
11 11  sql.close()
12 12  {{/groovy}}
13 -
XWiki.XWikiComments[1]
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.RicardoJulioRodriguezFernandez
Comment
... ... @@ -1,1 +1,0 @@
1 -https://docs.groovy-lang.org/latest/html/documentation/sql-userguide.html
Date
... ... @@ -1,1 +1,0 @@
1 -2024-03-12 09:39:23.722
XWiki.XWikiComments[2]
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.RicardoJulioRodriguezFernandez
Comment
... ... @@ -1,1 +1,0 @@
1 -https://groovy-lang.org/databases.html#_reading_rows
Date
... ... @@ -1,1 +1,0 @@
1 -2024-03-12 09:39:33.285
XWiki.XWikiComments[3]
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.RicardoJulioRodriguezFernandez
Comment
... ... @@ -1,1 +1,0 @@
1 -https://www.xwiki.org/xwiki/bin/view/Documentation/DevGuide/Architecture/URL%20Architecture/Standard%20URL%20Format/
Date
... ... @@ -1,1 +1,0 @@
1 -2024-03-12 09:40:02.365