Wiki source code of Team

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

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
20.1	8	println "\|=num\|=Pid\|= Surname\|= Name\|= Category"
18.2	9	sql.execute "SET @row_number = 0"
21.1	10	sql.rows("SELECT (@row_number:=@row_number + 1) AS num,
	11	PersonnelID,
	12	Surname,
	13	Name,
	14	Category
	15	FROM IGFAE_Personnel ORDER BY Surname").each{
20.1	16	println "\|${it.num}\|${it.PersonnelID}\|${it.Surname}\|${it.Name}\|${it.Category}"
1.1	17	}
	18	sql.close()
	19
	20	{{/groovy}}

Applications