Template:LoadQualifications: Difference between revisions

Latest revision as of 06:54, 3 June 2024

Year	Institute	Academic and Professional Qualifications

@@ Line 1: / Line 1: @@
+==Declared Educational and Professional Qualifications ==
-{{#vardefine:LastColnPos|{{#rpos:{{PAGENAME}}|:}}}}
+{{#vardefine:LastColnPos2|{{#rpos:{{PAGENAME}}|:}}}}
-{{#vardefine:LastColnNextPos|{{#expr:{{#var:LastColnPos}}+1}}}}
+{{#vardefine:LastColnNextPos2|{{#expr:{{#var:LastColnPos2}}+1}}}}
-{{#vardefine:FindSNo|{{#sub:{{PAGENAME}}|{{#var:LastColnNextPos}}}}}}
+{{#vardefine:FindSNo2|{{#sub:{{PAGENAME}}|{{#var:LastColnNextPos2}}}}}}
+{{#vardefine:TrimFindSNo2|{{#sub:{{#var:FindSNo2}}|0|{{#expr:{{#len:{{#var:FindSNo2}}}}-1}}}}}}
+{{#get_db_data:
-{{#len:{{#var:FindSNo}}}}
+|server=drck-db
+|from=wikiqualifications
+|where=(SNo='{{#var:TrimFindSNo2}}')
-{{#sub:{{#var:FindSNo}}|0|{{#len:{{#var:FindSNo}}}}-1}}
+|order by=SNo, Year ASC
-|data=Year=Year,name=name,ExamName=ExamName
+|data=SNo2=SNo,Year2=Year,name2=name,ExamName2=ExamName
 }}
-{{#var:FindSNo}}
 {| class="wikitable"
-|+ Declared Educational and Professional Qualifications
 |-
 ! Year
@@ Line 24: / Line 19: @@
 {{#for_external_table:<nowiki/>
 {{!}}-
-{{!}} {{{Year}}}
+{{!}} {{{Year2}}}
-{{!}} {{{name}}}
+{{!}} {{{name2}}}
-{{!}} {{{ExamName}}}
+{{!}} {{{ExamName2}}}
 }}
 |}