Wiki source code of Team
Version 18.2 by Ricardo Julio Rodríguez Fernández on 2024/01/20 10:12
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 | |||
![]() |
18.1 | 8 | println "|=Pid|= Surname|= Name|= Category" |
![]() |
18.2 | 9 | sql.execute "SET @row_number = 0" |
![]() |
18.1 | 10 | sql.rows("SELECT PersonnelID,Surname,Name,Category FROM IGFAE_Personnel ORDER BY Surname").each{ |
11 | println "|${it.PersonnelID}|${it.Surname}|${it.Name}|${it.Category}" | ||
![]() |
1.1 | 12 | } |
13 | sql.close() | ||
14 | |||
15 | {{/groovy}} |