Template:Loadpersonaldata: Difference between revisions

Revision as of 07:19, 9 December 2023

Name	Admitted On	Photo

@@ Line 1: / Line 1: @@
-{{#vardefine:LastColnPos|{{#rpos:{{PAGENAME}}|:}}}}
-{{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}}
+{{#vardefine:Year|{{#expr: {{#sub:{{PAGENAME}}|-4|4}} }} }}
-{{#vardefine:FindSNo|{{#sub:{{PAGENAME}}|{{#var:LastColnNextPos}}}}}}
+{{#vardefine:From|'{{#var:Year}}/01/01'}}
+{{#vardefine:To|'{{#var:Year}}/12/31'}}
+{{#get_db_data:
+|server=drck-db
+|from=wikiaffilations
+|where=(AffiliationGroupID='1') and (AffilatedFrom>={{#var:From}} ) and (AffilatedFrom<={{#var:To}})
+|order by=LastName ASC
+|data=SNo=SNo,LastName=LastName,Initials=Initials, Photo=Photo,FirstName=FirstName, ID=ID, Title=Title, Photo=Photo, AffilatedFrom=AffilatedFrom,AffilationTo=AffilationTo
+}}
+{| class="wikitable"
+! Name
+! Admitted On
+! Photo{{#for_external_table:<nowiki/>
+{{!}}-
+{{!}} [[{{{LastName}}} {{{Initials}}} (SNo:{{{SNo}}})|{{{Title}}} {{{LastName}}} {{{Initials}}} ( {{{FirstName}}})]]
+{{!}} {{{AffilatedFrom}}}
+{{!}} {{{Photo}}}
+}}
+|}