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
ee382e3bb6dc94057b7780f9619504c5 2025-04-17 apple fruits things
c842d05dfb1d1ca4615744c9ba87189c 2025-04-17 banana fruits things
07e77820c1caf666d879dea858e9f6f5 2025-04-17 cat animals things
c3c9f44d33bd938278701ba5dd743f03 2025-04-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.