[FEATURE]: Custom Fields: I can search for the contents of custom fields #196

New issue

Open

opened 2025-11-10 16:10:44 +01:00 by simon · 3 comments

simon commented

2025-11-10 16:10:44 +01:00

Owner

Description

As head of an association, I want to search/filter for the contents of custom fields

Acceptance criteria

The same search/filter functionality operating on default fields applies to custom fields

## Description As head of an association, I want to search/filter for the contents of custom fields ## Acceptance criteria - [ ] The same search/filter functionality operating on default fields applies to custom fields

simon added this to the I can add custom fields milestone 2025-11-10 16:10:44 +01:00

simon added the

label 2025-11-10 16:10:45 +01:00

simon added a new dependency 2025-11-10 16:11:26 +01:00

#194 Custom Fields: Harden implementation

carla changed title from ~~Custom Fields: I can search for the contents of custom fields~~ to [FEATURE]: Custom Fields: I can search for the contents of custom fields

2025-12-01 21:08:10 +01:00

rafael commented

2025-12-01 21:13:18 +01:00

Collaborator

To do this, we need to put values of custom fields into the search_vector column on the member resource. This means we need to update the trigger defined here.

It now needs to run on multiple occasions:

when hardcoded member fields change
when values of custom fields change

when it runs, the custom field values for the member being updated need to be put into the search_vector value.

To do this, we need to put values of custom fields into the `search_vector` column on the member resource. This means we need to update the trigger defined [here](https://git.local-it.org//src/commit/e803dbdf8bbb290a83aa830967e5ad198a0956a8/priv/repo/migrations/20250912085235_AddSearchVectorToMembers.exs#L22-L40). It now needs to run on multiple occasions: - when hardcoded member fields change - when values of custom fields change when it runs, the custom field values for the member being updated need to be put into the `search_vector` value.

moritz added this to the Sprint 9: 20.11 - 11.12 project 2025-12-03 17:06:50 +01:00

carla commented

2025-12-03 20:13:39 +01:00

Owner

We could for now also start with a simple contains query and than implement fuzzy search later on.

carla added the

high priority

label 2025-12-04 12:56:42 +01:00

carla self-assigned this 2025-12-04 13:02:14 +01:00

carla commented

2025-12-04 15:24:00 +01:00

Owner

Things that came to my mind during implementation and summe up in other issues.
#264
#265

Things that came to my mind during implementation and summe up in other issues. https://git.local-it.org/local-it/mitgliederverwaltung/issues/264 https://git.local-it.org/local-it/mitgliederverwaltung/issues/265

carla changed reference from ~~main~~ to feature/196_search_custom_fields

2025-12-04 15:49:26 +01:00