Wiki source code of Team
Version 17.1 by Ricardo Julio Rodríguez Fernández on 2024/01/20 09:42
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
10.1 | 1 | {{sortable_tables filterable="yes" sticky="yes"/}} |
| 2 | |||
| |
1.1 | 3 | {{groovy}} |
| 4 | import groovy.sql.Sql | ||
| 5 | |||
| 6 | def sql = new Sql(services.component.getConnection()) | ||
| 7 | |||
| |
17.1 | 8 | println "|=n|=Pid|= Surname|= Name|= Category" |
| 9 | sql.rows("SELECT ROW_NUMBER() AS n, PersonnelID, Surname, Name, Category FROM IGFAE_Personnel ORDER BY Surname").each{ | ||
| 10 | println "|${it.n}|${it.PersonnelID}|${it.Surname}|${it.Name}|${it.Category}" | ||
| |
1.1 | 11 | } |
| 12 | sql.close() | ||
| 13 | |||
| 14 | {{/groovy}} |