Wiki source code of 10 random team's members
Last modified by Ricardo Julio Rodríguez Fernández on 2024/03/11 19:31
Show last authors
author | version | line-number | content |
---|---|---|---|
1 | {{groovy}} | ||
2 | import groovy.sql.Sql | ||
3 | |||
4 | def sql = new Sql(services.igfaebbdddummy.getConnection()) | ||
5 | println "(% class='doOddEven filterable grid sortable' id='tableid' %)" | ||
6 | println "(% class='sortHeader' %)|=n|=Pid|= Surname|= Name|= Category" | ||
7 | sql.execute "SET @row_number = 0" | ||
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{ | ||
9 | println "|${it.n}|${it.PersonnelID}|${it.Surname}|${it.Name}|${it.Category}" | ||
10 | } | ||
11 | sql.close() | ||
12 | |||
13 | {{/groovy}} |