Employees: Difference between revisions

← Older edit Newer 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:
+ {{#for_external_table:
-    |{{!}}-
+  |{{!}}-
-    {{!}} {{{officeAddress}}} {{!}}{{!}} [[{{{officeCity}}}]] {{!}}{{!}} {{{officeState}}} {{!}}{{!}} {{{officeZip}}}
+  {{!}}
-  }}
+  {{{empFirst}}}
+  {{{empLast}}}
+  {{!}}
+  {{!}}
+  [[{{{empOffice}}}]]
+  {{!}}
+  {{!}}
+  {{{empRole}}}
+ }}
 |}
-{{#get_db_data:
- |db = DataDemo
- |query = employeeQuery
- |data = empFirst=emp_first, empLast=emp_last, empOffice=office_city, empRole=emp_role
-}}
-<div align="center">
- {| class="wikitable"
-  ! Name !! Office !! Role
-  {{#for_external_table:
-   |{{!}}-
-   {{!}}
-   {{{empFirst}}}
-   {{{empLast}}}
-   {{!}}
-   {{!}}
-   [[{{{empOffice}}}]]
-   {{!}}
-   {{!}}
-   {{{empRole}}}
-  }}
- |}
-</div>