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 28.4
edited by Ricardo Julio Rodríguez Fernández
on 2024/03/12 09:39
Change comment: Added comment
To version 41.3
edited by Ricardo Julio Rodríguez Fernández
on 2024/03/13 12:06
Change comment: allow view right for XWiki.XWikiAdminGroup

Summary

Details

Page properties
Content
... ... @@ -1,10 +1,14 @@
1 +
2 +
1 1  {{groovy}}
2 2  import groovy.sql.Sql
3 3  def sql = new Sql(services.igfaebbdddummyas.getConnection())
4 4  
5 - sql.eachRow('SELECT * FROM json'){
6 - println "${it.room_title}"
7 - }
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 +}
8 8  
9 9  sql.close()
10 10  {{/groovy}}
13 +
14 +
XWiki.XWikiComments[3]
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.RicardoJulioRodriguezFernandez
Comment
... ... @@ -1,0 +1,1 @@
1 +https://www.xwiki.org/xwiki/bin/view/Documentation/DevGuide/Architecture/URL%20Architecture/Standard%20URL%20Format/
Date
... ... @@ -1,0 +1,1 @@
1 +2024-03-12 09:40:02.365
XWiki.XWikiRights[0]
Allow/Deny
... ... @@ -1,0 +1,1 @@
1 +Allow
Levels
... ... @@ -1,0 +1,1 @@
1 +view
Users
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
XWiki.XWikiRights[1]
Allow/Deny
... ... @@ -1,0 +1,1 @@
1 +Allow
Groups
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiAdminGroup
Levels
... ... @@ -1,0 +1,1 @@
1 +view