Cannot resolve keyword 'min_similarity' into field. Choices are: ...

[daudln]

Hello guys, I am implementing Global search to my models using search (keyword) field with TrigramSimilarity

@strawberry_django.filter_type(BaseModel)
class BaseModelFilter:
    id: strawberry.Maybe[GlobalID]
    is_active: auto

    min_similarity: Optional[float] = strawberry_django.filter_field(default=0.3)

    @strawberry_django.filter_field(name='keyword')
    def search(
        self,
        info: Info,
        queryset: QuerySet,
        value: str,
        prefix: str,
    ) -> tuple[QuerySet, Q]:
        if not value:
            return queryset, Q()

        threshold = 0.3 if self.min_similarity is strawberry.UNSET else self.min_similarity

        if not is_postgres():
            queryset = get_search_alias(queryset)
            return queryset, Q(**{f'{prefix}searchable_text__icontains': value})

        search_fields = get_search_fields(queryset.model)
        if not search_fields:
            return queryset, Q()

        # We use the first field as the primary ranking field
        rank_field = f'{prefix}{search_fields[0]}'
        similarity_alias = 'search_similarity'

        # Annotate similarity
        queryset = queryset.annotate(**{similarity_alias: TrigramSimilarity(rank_field, value)})
        q = Q(**{f'{similarity_alias}__gte': threshold})

        for field in search_fields[1:]:
            field_path = f'{prefix}{field}'
            field_sim_alias = f'sim_{field}'
            queryset = queryset.annotate(**{field_sim_alias: TrigramSimilarity(field_path, value)})
            q |= Q(**{f'{field_sim_alias}__gte': threshold})

        return queryset.order_by(F(similarity_alias).desc()), q

1. Is it worth?
2. Where you I improve?
3. And my question is, how to use implement: min_similarity for my current implementation I am getting an error that;- Cannot resolve keyword 'min_similarity' into field. Choices are: ...

[bellini666]

Hi @daudln ,

I think it is ok, I've done something similar in some projects using strawberry + strawberry_django, by having a search field in the filter type.

And my question is, how to use implement: min_similarity for my current implementation I am getting an error that;- Cannot resolve keyword 'min_similarity' into field. Choices are: ...

Where exactly are you getting this? Can you share the full traceback?

[daudln]

@bellini666 any response on this?

[bellini666]

Hi @daudln, sorry, tough week 😅

Do you have the full traceback? It doesn't matter if it is big

[daudln]

Hi @daudln, sorry, tough week 😅

Do you have the full traceback? It doesn't matter if it is big

Sorry for that 😅

Traceback (most recent call last):
  File ".venv/lib/python3.14/site-packages/graphql/execution/execute.py", line 530, in await_result
    return_type, field_nodes, info, path, await result
                                          ^^^^^^^^^^^^
  File ".venv/lib/python3.14/site-packages/sentry_sdk/integrations/strawberry.py", line 266, in resolve
    return await self._resolve(_next, root, info, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File ".venv/lib/python3.14/site-packages/sentry_sdk/integrations/strawberry.py", line 253, in _resolve
    result = await result
             ^^^^^^^^^^^^
  File ".venv/lib/python3.14/site-packages/strawberry_django/fields/field.py", line 567, in async_resolver
    get_queryset(await queryset),
                 ^^^^^^^^^^^^^^
  File ".venv/lib/python3.14/site-packages/asgiref/sync.py", line 506, in __call__
    ret = await asyncio.shield(exec_coro)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File ".venv/lib/python3.14/site-packages/asgiref/current_thread_executor.py", line 40, in run
    result = self.fn(*self.args, **self.kwargs)
  File ".venv/lib/python3.14/site-packages/asgiref/sync.py", line 561, in thread_handler
    return func(*args, **kwargs)
  File ".venv/lib/python3.14/site-packages/strawberry_django/resolvers.py", line 109, in async_resolver
    return sync_resolver(*args, **kwargs)
  File ".venv/lib/python3.14/site-packages/strawberry_django/resolvers.py", line 87, in sync_resolver
    retval = resolver(*args, **kwargs)
  File ".venv/lib/python3.14/site-packages/strawberry_django/fields/field.py", line 300, in qs_hook
    return self.get_queryset(qs, info, **kwargs)
           ~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^
  File ".venv/lib/python3.14/site-packages/strawberry_django/fields/field.py", line 351, in get_queryset
    queryset = super().get_queryset(
        filter_with_perms(queryset, info), info, **kwargs
    )
  File ".venv/lib/python3.14/site-packages/strawberry_django/pagination.py", line 415, in get_queryset
    queryset = super().get_queryset(queryset, info, **kwargs)
  File ".venv/lib/python3.14/site-packages/strawberry_django/ordering.py", line 373, in get_queryset
    queryset = super().get_queryset(queryset, info, **kwargs)
  File ".venv/lib/python3.14/site-packages/strawberry_django/filters.py", line 389, in get_queryset
    return apply(filters, queryset, info, pk)
  File ".venv/lib/python3.14/site-packages/strawberry_django/filters.py", line 292, in apply
    queryset = queryset.filter(q)
  File ".venv/lib/python3.14/site-packages/django/db/models/query.py", line 1542, in filter
    return self._filter_or_exclude(False, args, kwargs)
           ~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^
  File ".venv/lib/python3.14/site-packages/django/db/models/query.py", line 1560, in _filter_or_exclude
    clone._filter_or_exclude_inplace(negate, args, kwargs)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^
  File ".venv/lib/python3.14/site-packages/django/db/models/query.py", line 1570, in _filter_or_exclude_inplace
    self._query.add_q(Q(*args, **kwargs))
    ~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^
  File ".venv/lib/python3.14/site-packages/django/db/models/sql/query.py", line 1676, in add_q
    clause, _ = self._add_q(q_object, can_reuse)
                ~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^
  File ".venv/lib/python3.14/site-packages/django/db/models/sql/query.py", line 1708, in _add_q
    child_clause, needed_inner = self.build_filter(
                                 ~~~~~~~~~~~~~~~~~^
        child,
        ^^^^^^
    ...<7 lines>...
        update_join_types=update_join_types,
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File ".venv/lib/python3.14/site-packages/django/db/models/sql/query.py", line 1533, in build_filter
    return self._add_q(
           ~~~~~~~~~~~^
        filter_expr,
        ^^^^^^^^^^^^
    ...<7 lines>...
        update_join_types=update_join_types,
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File ".venv/lib/python3.14/site-packages/django/db/models/sql/query.py", line 1708, in _add_q
    child_clause, needed_inner = self.build_filter(
                                 ~~~~~~~~~~~~~~~~~^
        child,
        ^^^^^^
    ...<7 lines>...
        update_join_types=update_join_types,
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File ".venv/lib/python3.14/site-packages/django/db/models/sql/query.py", line 1556, in build_filter
    lookups, parts, reffed_expression = self.solve_lookup_type(arg, summarize)
                                        ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^
  File ".venv/lib/python3.14/site-packages/django/db/models/sql/query.py", line 1363, in solve_lookup_type
    _, field, _, lookup_parts = self.names_to_path(lookup_splitted, self.get_meta())
                                ~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File ".venv/lib/python3.14/site-packages/django/db/models/sql/query.py", line 1842, in names_to_path
    raise FieldError(
    ...<2 lines>...
    )
django.core.exceptions.FieldError: Cannot resolve keyword 'min_similarity' into field. Choices are: code, combined_score, created_at, created_by, created_by_id, deleted_at, deleted_by, deleted_by_id, id, is_active, is_deleted, name, napa_id, search_rank, trigram_sim, unique_id, updated_at, updated_by, updated_by_id, ward, ward_id

[bellini666]

Ok, this was an actual thing we didn't have support for 😅

Added support to exclude that field from queryset filter on https://github.com/strawberry-graphql/strawberry-django/releases/tag/0.78.0

Documentation about it will also be available in some minutes at https://strawberry.rocks/docs/django/guide/filters

Let me know if that fixes the issue for you :)

[daudln]

Ok, this was an actual thing we didn't have support for 😅

Added support to exclude that field from queryset filter on https://github.com/strawberry-graphql/strawberry-django/releases/tag/0.78.0

Documentation about it will also be available in some minutes at https://strawberry.rocks/docs/django/guide/filters

Let me know if that fixes the issue for you :)

That works🎯