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 |
||
(4 intermediate revisions by the same user not shown) | |||
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}}) | ||
|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 13: | ||
{| class="wikitable" | {| class="wikitable" | ||
! Name | ! Name | ||
! Admitted On | |||
! Photo{{#for_external_table:<nowiki/> | ! Photo{{#for_external_table:<nowiki/> | ||
{{!}}- | {{!}}- | ||
{{!}} [[ | {{!}} [[{{{LastName}}} {{{Initials}}} (SNo:{{{SNo}}})|{{{Title}}} {{{LastName}}} {{{Initials}}} ( {{{FirstName}}})]] | ||
{{!}} | {{!}} {{{AffilatedFrom}}} | ||
{{!}} {{{Photo}}} | |||
}} | }} | ||
|} | |} |
Latest revision as of 17:20, 17 August 2019
Name | Admitted On | Photo |
---|