Template:Loadpersonaldata: Difference between revisions

Latest revision as of 06:46, 3 June 2024

@@ Line 1: / Line 1: @@
+__NOEDITSECTION__
-{{#vardefine:Year|{{#expr: {{#sub:{{PAGENAME}}|-4|4}} }} }}
+{{#vardefine:LastColnPos|{{#rpos:{{PAGENAME}}|:}}}}
-{{#vardefine:From|'{{#var:Year}}/01/01'}}
+{{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}}
-{{#vardefine:To|'{{#var:Year}}/12/31'}}
+{{#vardefine:FindSNo|{{#sub:{{PAGENAME}}|{{#var:LastColnNextPos}}}}}}
 {{#get_db_data:
-|server=drck-db
+|db=drck-db
 |from=wikiaffilations
-|where=(AffiliationGroupID='1') and (AffilatedFrom>={{#var:From}} ) and (AffilatedFrom<={{#var:To}})
+|where=(SNo='{{#var:FindSNo}}')
 |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
+{{#for_external_table:<nowiki/>
-! Admitted On
-! Photo{{#for_external_table:<nowiki/>
 {{!}}-
-{{!}} [[{{{LastName}}} {{{Initials}}} (SNo:{{{SNo}}})|{{{Title}}} {{{LastName}}} {{{Initials}}} ( {{{FirstName}}})]]
+{{!}} {{{FirstName}}} {{{LastName}}}
-{{!}} {{{AffilatedFrom}}}
 {{!}} {{{Photo}}}
 }}
 |}