Wiki source code of Team
Version 28.1 by Ricardo Julio Rodríguez Fernández on 2024/01/20 15:16
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | |||
| 2 | {{groovy}} | ||
| 3 | import groovy.sql.Sql | ||
| 4 | |||
| 5 | def sql = new Sql(services.component.getConnection()) | ||
| 6 | |||
| 7 | println "|=num|=Pid|= Surname|= Name|= Category" | ||
| 8 | sql.execute "SET @row_number = 0" | ||
| 9 | sql.rows("SELECT (@row_number:=@row_number + 1) AS num,PersonnelID,Surname,Name,CASE WHEN Category LIKE '%management%' THEN 'Rm&T staff' ELSE Category END AS Category FROM IGFAE_Personnel ORDER BY Surname").each{ | ||
| 10 | println "|${it.num}|${it.PersonnelID}|${it.Surname}|${it.Name}|${it.Category}" | ||
| 11 | } | ||
| 12 | sql.close() | ||
| 13 | |||
| 14 | {{/groovy}} |