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:LastColnPos2|{{#rpos:{{PAGENAME}}|:}}}}
 {{#vardefine:LastColnNextPos2|{{#expr:{{#var:LastColnPos2}}+1}}}}
 {{#vardefine:FindSNo2|{{#sub:{{PAGENAME}}|{{#var:LastColnNextPos2}}}}}}
 {{#vardefine:TrimFindSNo2|{{#sub:{{#var:FindSNo2}}|0|{{#expr:{{#len:{{#var:FindSNo2}}}}-1}}}}}}
-{{#var:TrimFindSNo2}}
 {{#get_db_data:
-|db=drck-db
+|server=drck-db
 |from=wikiqualifications
-|order by=ID
+|where=(SNo='{{#var:TrimFindSNo2}}')
-|data=ID=ID,SNo=SNo,Year=Year,name=name,ExamName=ExamName, FullString=FullString
+|order by=SNo, Year ASC
+|data=SNo2=SNo,Year2=Year,name2=name,ExamName2=ExamName
 }}
-{{#var:TrimFindSNo2}}
 {| class="wikitable"
-|+ Declared Educational and Professional Qualifications
 |-
-! ID
-! SNo
 ! Year
 ! Institute
 ! Academic and Professional Qualifications
-! FullString
 |-
 {{#for_external_table:<nowiki/>
 {{!}}-
-{{!}} {{{ID}}}
+{{!}} {{{Year2}}}
-{{!}} {{{SNo}}}
+{{!}} {{{name2}}}
-{{!}} {{{Year}}}
+{{!}} {{{ExamName2}}}
-{{!}} {{{name}}}
-{{!}} {{{ExamName}}}
-{{!}} {{{FullString}}}
 }}
 |}