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
6dd8f3adde1e3ccb9c8c0ca3ca9410cd 2024-06-17 apple fruits things
72ef43e5ad89851a094e9e5bdbc93aa5 2024-06-17 banana fruits things
eea8e5b8a9da9d767c1f2be6c0f76aea 2024-06-17 cat animals things
aaeaec33f87fb54c2b5fd04b81c05a51 2024-06-17 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.