Wiki source code of Team
Version 9.1 by Ricardo Julio Rodríguez Fernández on 2024/01/16 15:18
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 | |||
| |
8.1 | 6 | println "|=Pid|= Surname|= Name|= Category" |
| 7 | sql.eachRow("SELECT PersonnelID,Surname,Name,Category FROM IGFAE_Personnel ORDER BY Surname"){ | ||
| 8 | println "|${it.PersonnelID}|${it.Surname}|${it.Name}|${it.Category}" | ||
| |
1.1 | 9 | } |
| 10 | sql.close() | ||
| 11 | |||
| 12 | {{/groovy}} | ||
| |
7.1 | 13 | |
| 14 | Page reference: {{velocity}}$doc.documentReference{{/velocity}} | ||
| 15 |