[FEATURE]: Implement fuzzy and substring search for members #162

New issue

Closed

opened 2025-09-17 14:53:36 +02:00 by carla · 0 comments

carla commented

2025-09-17 14:53:36 +02:00

Owner

Description

As a user I can search for substrings in the search input field in the members list and I get results for memebers that contain the substring and contain them approximately (fuzzy search)

Acceptance criteria

I can enter a substring search term and get correct results

Notes

Could be implemented by adding Trigram:

search_vector @@ plainto_tsquery('german', 'lauf')

OR name ILIKE '%lauf%'
OR name % 'lauf'

links for further reading:
Postgres docu functions
Postgres docu Trigram

## Description As a user I can search for substrings in the search input field in the members list and I get results for memebers that contain the substring and contain them approximately (fuzzy search) ## Acceptance criteria - [x] I can enter a substring search term and get correct results ## Notes Could be implemented by adding Trigram: ``` search_vector @@ plainto_tsquery('german', 'lauf') OR name ILIKE '%lauf%' OR name % 'lauf' ``` links for further reading: [Postgres docu functions](https://www.postgresql.org/docs/17/functions-textsearch.html) [Postgres docu Trigram](https://www.postgresql.org/docs/17/pgtrgm.html)