Wiki source code of Team

Version 28.1 by Ricardo Julio Rodríguez Fernández on 2024/01/20 15:16

version	line-number	content
10.1	1
1.1	2	{{groovy}}
	3	import groovy.sql.Sql
	4
	5	def sql = new Sql(services.component.getConnection())
	6
20.1	7	println "\|=num\|=Pid\|= Surname\|= Name\|= Category"
18.2	8	sql.execute "SET @row_number = 0"
26.1	9	sql.rows("SELECT (@row_number:=@row_number + 1) AS num,PersonnelID,Surname,Name,CASE WHEN Category LIKE '%management%' THEN 'Rm&T staff' ELSE Category END AS Category FROM IGFAE_Personnel ORDER BY Surname").each{
20.1	10	println "\|${it.num}\|${it.PersonnelID}\|${it.Surname}\|${it.Name}\|${it.Category}"
1.1	11	}
	12	sql.close()
	13
	14	{{/groovy}}

Applications