List of Categorized Items

This page uses a Hashtag List to show all Categorized Items matching any search filters.   The filter form and list table are both styled using Bootstrap 3 default theme classes.  
ID Created On Name Categories
0c36732d5f2671b75e60eff5be40e53d 2020-05-24 apple fruits things
0ba0223ac19038b3404a122d8b4620b5 2020-05-24 banana fruits things
098ab5ddfe13daed18200114a60f59e2 2020-05-24 cat animals things
f5fabb63408bb466b41d31fa5b83b0b4 2020-05-24 dog animals things


Processed this Hashtag Markup:
<# start list for items;
	relate id to item_categorizations.item_id;
	relate item_categorizations.category_id to categories.id;
	include when categories.name in "<#[url.filter]#>" if set;
	sort by items.name, items.id;
#>

<# start header #>
<table class="table table-striped table-hover">
	<thead>
	<tr>
		<th>ID</th>
		<th>Created On</th>
		<th>Name</th>
		<th>Categories</th>
	</tr>
	</thead>
<# end header #>

<# start row #>
	<tr>
		<td title="<# id #>"><span class="truncated monospace"><# id #></span></td>
		<td><# created_on as date "Y-M-D" #></td>
		<td><# name as html #></td>
		<td><# start row loop for items.id; #>
			<span class="label label-success"><# categories.name as html #></span>
			<# end loop #>
		</td>
	</tr>
<# end row #>

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

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

<# end list #>


The Categories Mini-App uses the Hashtag Markup Language to demonstrate a method of categorizing items.

Categories, Items, and Item Categorization records are all stored in an SQL Database.  

Search filters are demonstrated to only List Items that have been Categorized to match any value from a comma separated list.