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.  

No Offices Found

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.