Wiki source code of Team
Version 29.1 by Ricardo Julio Rodríguez Fernández on 2024/01/20 15:16
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
29.1 | 1 | {{sortable_tables filterable="yes" sticky="yes"/}} |
| |
10.1 | 2 | |
| |
1.1 | 3 | {{groovy}} |
| 4 | import groovy.sql.Sql | ||
| 5 | |||
| 6 | def sql = new Sql(services.component.getConnection()) | ||
| 7 | |||
| |
20.1 | 8 | println "|=num|=Pid|= Surname|= Name|= Category" |
| |
18.2 | 9 | sql.execute "SET @row_number = 0" |
| |
26.1 | 10 | 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{ |
| |
20.1 | 11 | println "|${it.num}|${it.PersonnelID}|${it.Surname}|${it.Name}|${it.Category}" |
| |
1.1 | 12 | } |
| 13 | sql.close() | ||
| 14 | |||
| 15 | {{/groovy}} |