Template:Students: Difference between revisions
Jump to navigation
Jump to search
Kamalanath (talk | contribs) (Created page with "{{#get_db_data: |server=drck-db |from=wikiaffilations |where=(AffiliationGroupID='1') and (AffilatedFrom>='1970/01/01') and (AffilatedFrom<='1970/12/31') |limit=100 |order by=...") |
Kamalanath (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
{{#vardefine:Year|{{#expr: {{#sub:{{PAGENAME}}|-4|4}} }} }} | |||
{{#vardefine:From|'{{#var:Year}}/01/01'}} | |||
{{#vardefine:To|'{{#var:Year}}/12/31'}} | |||
{{#get_db_data: | {{#get_db_data: | ||
|server=drck-db | |server=drck-db | ||
|from=wikiaffilations | |from=wikiaffilations | ||
|where=(AffiliationGroupID='1') and (AffilatedFrom>= | |where=(AffiliationGroupID='1') and (AffilatedFrom>={{#var:From}} ) and (AffilatedFrom<={{#var:To}}) | ||
|limit= | |limit=500 | ||
|order by=LastName ASC | |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 | |data=SNo=SNo,LastName=LastName,Initials=Initials, Photo=Photo,FirstName=FirstName, ID=ID, Title=Title, Photo=Photo, AffilatedFrom=AffilatedFrom,AffilationTo=AffilationTo | ||
| Line 10: | Line 14: | ||
{| class="wikitable" | {| class="wikitable" | ||
! Name | ! Name | ||
! Admitted On | |||
! Photo{{#for_external_table:<nowiki/> | ! Photo{{#for_external_table:<nowiki/> | ||
{{!}}- | {{!}}- | ||
{{!}} [[Principal {{{Title}}} {{{LastName}}} {{{Initials}}} |{{{Title}}} {{{LastName}}} {{{Initials}}} ( {{{FirstName}}})]] | {{!}} [[Principal {{{Title}}} {{{LastName}}} {{{Initials}}} |{{{Title}}} {{{LastName}}} {{{Initials}}} ( {{{FirstName}}})]] | ||
{{!}} | {{!}} {{{AffilatedFrom}}} | ||
{{!}} {{{Photo}}} | |||
}} | }} | ||
|} | |} | ||
Revision as of 16:10, 17 August 2019
| Name | Admitted On | Photo |
|---|