Employees: Difference between revisions

From ExternalDataDemo
Jump to navigation Jump to search
(Created page with "{{#get_db_data: |db = DataDemo |query = employee |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}}} }} |}")
 
No edit summary
Line 6: Line 6:
{| class="wikitable"
{| class="wikitable"
! Name !! Office !! Role
! Name !! Office !! Role
  {{#for_external_table:  
{{#for_external_table:  
|{{!}}-
|{{!}}-
{{!}} {{{empFirst}}} {{{empLast}}} {{!}}{{!}} {{{empOffice}}} {{!}}{{!}} {{{empRole}}}
{{!}} {{{empFirst}}} {{{empLast}}} {{!}}{{!}} {{{empOffice}}} {{!}}{{!}} {{#switch: {{{empRole}}}
  }}
| 1 = Manager
| 2 = Receptionist
| #default = {{#if: {{{empRole|}}} | Unknown | }} }}
}}
|}
|}

Revision as of 15:28, 3 June 2024

The prepared statement employee is not set up for the database ID DataDemo.

Name Office Role