From a80c0ce95f98ae826789d0161fded4dfd2999820 Mon Sep 17 00:00:00 2001 From: Aspen Smith Date: Sun, 24 Mar 2024 14:31:47 -0400 Subject: feat(web/panettone): Support full-text search of issues Support basic full text search of issues using postgresql's built-in text search. There's a new column on the issues table called `tsv`, which contains a tsvector of the title concatenated with the description, and a new search form on both the index and closed issues page which allows searching that tsvector with a user-supplied query. Results are ranked according to that text query in the case of a search. This works fine for now, but next up I'd also like to highlight the results according to the bits that matched the user's query. Change-Id: I25170bedbbbcdc3ed29a047962e9fcfe280d763a Reviewed-on: https://cl.tvl.fyi/c/depot/+/11258 Autosubmit: aspen Tested-by: BuildkiteCI Reviewed-by: sterni --- web/panettone/src/static/search.png | Bin 0 -> 711 bytes 1 file changed, 0 insertions(+), 0 deletions(-) create mode 100644 web/panettone/src/static/search.png (limited to 'web/panettone/src/static') diff --git a/web/panettone/src/static/search.png b/web/panettone/src/static/search.png new file mode 100644 index 000000000000..0fd78c665120 Binary files /dev/null and b/web/panettone/src/static/search.png differ -- cgit 1.4.1