Wiki source code of Team

Version 18.2 by Ricardo Julio Rodríguez Fernández on 2024/01/20 10:12

Hide last authors
Ricardo Julio Rodríguez Fernández 10.1 1 {{sortable_tables filterable="yes" sticky="yes"/}}
2
Ricardo Julio Rodríguez Fernández 1.1 3 {{groovy}}
4 import groovy.sql.Sql
5
6 def sql = new Sql(services.component.getConnection())
7
Ricardo Julio Rodríguez Fernández 18.1 8 println "|=Pid|= Surname|= Name|= Category"
Ricardo Julio Rodríguez Fernández 18.2 9 sql.execute "SET @row_number = 0"
Ricardo Julio Rodríguez Fernández 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}"
Ricardo Julio Rodríguez Fernández 1.1 12 }
13 sql.close()
14
15 {{/groovy}}