Changes for page Rooms
Last modified by Ricardo Julio Rodríguez Fernández on 2024/03/13 12:06
From version 28.3
edited by Ricardo Julio Rodríguez Fernández
on 2024/03/12 09:39
on 2024/03/12 09:39
Change comment:
Added comment
To version 33.1
edited by Abdullah Sharifi
on 2024/03/12 15:57
on 2024/03/12 15:57
Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
-
Objects (0 modified, 2 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. RicardoJulioRodriguezFernandez1 +XWiki.AbdullahSharifi - 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 * FROM json'){ 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;'){println "${it.room_title}"} 8 8 9 9 sql.close() 10 10 {{/groovy}}
- XWiki.XWikiComments[2]
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.RicardoJulioRodriguezFernandez - Comment
-
... ... @@ -1,0 +1,1 @@ 1 +https://groovy-lang.org/databases.html#_reading_rows - Date
-
... ... @@ -1,0 +1,1 @@ 1 +2024-03-12 09:39:33.285
- 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