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
be6ec9643d882e249fb6b4de14da4de1 2021-12-05 apple fruits things
073db449aeeebe14cf146809b34e7afb 2021-12-05 banana fruits things
cb5a013558f59934b6dbed068ea70509 2021-12-05 cat animals things
a9e3b3602f0ce31f45236b9dfd9bee94 2021-12-05 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.