Skip to content

Improve Typeahead search results #29

@SuperCheese21

Description

@SuperCheese21

Currently, we are using prisma "contains" queries to search for text matches inside our tables. This is an issue because Prisma is unable to order the results properly when searching in multiple columns.

To implement searching in multiple columns, we should use Prisma's built-in Full-Text Search: https://www.prisma.io/docs/concepts/components/prisma-client/full-text-search. This change should be made in the searchAirports, searchAirlines, and searchAircraftTypes endpoints.

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions