Editing Employees

{{#get_db_data:
 |db = DataDemo
 |query = employeeQuery
 |data = empFirst=emp_first, empLast=emp_last, empOffice=office_city, empRole=emp_role
}}
{| class="wikitable"
 ! Name !! Office !! Role
  {{#for_external_table:
    |{{!}}-
    {{!}} {{{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}}