Changes for page Predoctoral staff: historical record
Last modified by Ricardo Julio Rodríguez Fernández on 2025/07/13 08:08
From version 65.1
edited by Ricardo Julio Rodríguez Fernández
on 2025/07/13 07:54
on 2025/07/13 07:54
Change comment:
There is no comment for this version
To version 70.1
edited by Ricardo Julio Rodríguez Fernández
on 2025/07/13 08:07
on 2025/07/13 08:07
Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Title
-
... ... @@ -1,1 +1,1 @@ 1 -Predoctoral staff 1 +Predoctoral staff: historical record - Content
-
... ... @@ -5,8 +5,8 @@ 5 5 println "(% class='doOddEven filterable grid sortable' id='tableid' %)" 6 6 println "(% class='sortHeader' %)|= FirstSurname|= SecondSurname|= Name|= StartDate" 7 7 sql.execute "SET @row_number = 0" 8 - sql.rows("SELECT (@row_number:=@row_number + 1) AS n,P.FirstSurname,P.SecondSurname,P.Name,PC.StartDate,C.Name FROM Personnel AS P NATURAL JOIN PersonnelContract AS PC JOIN Contract AS C ON (PC.ContractID=C.ContractID) WHERE (C.Name REGEXP 'predoc X|FPI|FPU|Caixa' AND NOT(C.Name REGEXP 'ext') AND NOT(P.FirstSurname REGEXP 'Borsato|Alejo|Calderón|Fariña')) order by PC.StartDate,FirstSurname DESC").each{9 - println "|${it.FirstSurname}|${it.SecondSurname}|${it.Name}|${it.StartDate}" 8 + sql.rows("SELECT (@row_number:=@row_number + 1) AS n,P.FirstSurname,P.SecondSurname,P.Name AS PersonName,PC.StartDate,C.Name FROM Personnel AS P NATURAL JOIN PersonnelContract AS PC JOIN Contract AS C ON (PC.ContractID=C.ContractID) WHERE (C.Name REGEXP 'predoc X|FPI|FPU|Caixa' AND NOT(C.Name REGEXP 'ext') AND NOT(P.FirstSurname REGEXP 'Borsato|Alejo|Calderón|Fariña')) order by PC.StartDate DESC,P.FirstSurname").each{ 9 + println "|${it.FirstSurname}|${it.SecondSurname}|${it.PersonName}|${it.StartDate}" 10 10 } 11 11 sql.close() 12 12