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}}}
    }}
 |}
-{{#get_db_data:
+{{#switch: {{{empRole}}}| 1 = Manager | 2 = Receptionist | #default = {{#if: {{{empRole|}}} | Unknown | }}
- |db = DataDemo
- |query = employeeQuery
- |data = empFirst=emp_first, empLast=emp_last, empOffice=office_city, empRole=emp_role
+{{#switch: {{{empRole}}} |1=one |2=two |3|4|5=range 3–5 |other}}
-}}
-<div align="center">
- {| class="wikitable"
-  ! Name !! Office !! Role
-  {{#for_external_table:
-   |{{!}}-
-   {{!}}
-   {{{empFirst}}}
-   {{{empLast}}}
-   {{!}}
-   {{!}}
-   [[{{{empOffice}}}]]
-   {{!}}
-   {{!}}
-   {{{empRole}}}
-  }}
- |}
-</div>