From 9e779891fa91f44a9734b79ccb4f6aef48a0de3f Mon Sep 17 00:00:00 2001
From: Leonardo Bishop <me@leonardobishop.net>
Date: Thu, 18 Sep 2025 21:00:28 +0100
Subject: Add filters on html page

---
 pkg/database/query/entries.sql | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'pkg/database/query/entries.sql')

diff --git a/pkg/database/query/entries.sql b/pkg/database/query/entries.sql
index 9584adf..37d11ce 100644
--- a/pkg/database/query/entries.sql
+++ b/pkg/database/query/entries.sql
@@ -20,6 +20,12 @@ SELECT title, url, description, timestamp, kinds.name as kind_name, kinds.emoji
 JOIN kinds ON entries.kind == kinds.id
 ORDER BY timestamp DESC;
 
+-- name: GetEntriesByKind :many
+SELECT title, url, description, timestamp, kinds.name as kind_name, kinds.emoji as kind_emoji FROM entries
+JOIN kinds ON entries.kind == kinds.id
+WHERE kinds.name = ?
+ORDER BY timestamp DESC;
+
 -- name: GetEntryURLs :many
 SELECT url FROM entries
 ORDER BY timestamp DESC;
-- 
cgit v1.2.3-70-g09d2

