Wiki source code of 10 random team's members
Version 39.1 by Ricardo Julio Rodríguez Fernández on 2024/01/21 22:00
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
1.1 | 1 | {{groovy}} |
| 2 | import groovy.sql.Sql | ||
| 3 | |||
| 4 | def sql = new Sql(services.component.getConnection()) | ||
| 5 | |||
| |
31.1 | 6 | println "|=n|=Pid|= Surname|= Name|= Category" |
| |
18.2 | 7 | sql.execute "SET @row_number = 0" |
| |
33.1 | 8 | sql.rows("SELECT (@row_number:=@row_number + 1) AS n,PersonnelID,Surname,Name,CASE WHEN Category LIKE '%management%' THEN 'Rm&T staff' ELSE Category END AS Category FROM IGFAE_Personnel ORDER BY RAND() LIMIT 10").each{ |
| |
31.1 | 9 | println "|${it.n}|${it.PersonnelID}|${it.Surname}|${it.Name}|${it.Category}" |
| |
1.1 | 10 | } |
| 11 | sql.close() | ||
| 12 | |||
| 13 | {{/groovy}} |