Employees: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
 {{#get_db_data:
   |db = DataDemo
-  |query = office
+  |query = employeeQuery
-  |data=officeAddress=office_address, officeCity=office_city, officeState=office_state, officeZip=office_zip
+  |data = empFirst=emp_first, empLast=emp_last, empOffice=office_city, empRole=emp_role
 }}
-Testing the #external_value functionality:
-{{#external_value:officeCity}}
-Testing the wikitable functionality:
 {| class="wikitable"
-  ! Office Address !! City !! State !! Zip
+  ! Name !! Office !! Role
    {{#for_external_table:
      |{{!}}-
-     {{!}} {{{officeAddress}}} {{!}}{{!}} [[{{{officeCity}}}]] {{!}}{{!}} {{{officeState}}} {{!}}{{!}} {{{officeZip}}}
+     {{!}} {{{empFirst}}} {{{empLast}}} {{!}}{{!}} [[{{{empOffice}}}]] {{!}}{{!}} {{{empRole}}}
    }}
 |}
+{{#switch: {{{empRole}}}| 1 = Manager | 2 = Receptionist | #default = {{#if: {{{empRole|}}} | Unknown | }}
+{{#switch: {{{empRole}}} |1=one |2=two |3|4|5=range 3–5 |other}}