List of Offices with Related information

This page uses a Hashtag List to show all Office records, with related Country and Employee record information.   The Table is styled using Bootstrap 3 default theme classes.   A Row Loop is used to isolate a list of Employee Names for each Office.   An ISO Code is used to relate Offices to Countries.  
Office Name Country ISO Code Country Name Employees
Bay Area HQ USA United States of America Gregory Klein
Tiffany Schmidt
Beijing CHN China Zhang Wei
Chicago USA United States of America Bernie Polanski
London GBR United Kingdom Oliver Wellington
New York USA United States of America Kenny Gibbons
Vladimitry Medvetin
Paris FRA France Chen Linyao
Ethan Dubois


Processed this Hashtag Markup:
<# start list for offices;
	relate id to employees.office_id;
	relate country_iso_code to countries.iso_code;
	sort by offices.name, offices.id, employees.name;
#>

<# start header #>
<table class="table table-striped table-hover">
	<thead>
	<tr>
		<th>Office Name</th>
		<th>Country ISO Code</th>
		<th>Country Name</th>
		<th>Employees</th>
	</tr>
	</thead>
<# end header #>

<# start row #>
	<tr>
		<td><# name as html #></td>
		<td><# country_iso_code as html #></td>
		<td><# countries.name as html #></td>
		<td><# start row loop for offices.id; #>
			<# employees.name as html #><br>
			<# end row loop #>
		</td>
	</tr>
<# end row #>

<# start footer #>
</table>
<# end footer #>

<# start no results #>
<h4 class="alert alert-warning text-center">No Offices Found</h4>
<# end no results #>

<# end list #>

The Company Mini-App uses the Hashtag Markup Language to maintain multiple sets of records that relate to each other.

Records for Employees, Offices, and Countries are stored in an SQL Database.   Methods are provided to create, update, and delete any record.