Custom Search Implementation

[Dan6erbond]

The admin.listSearchableFields configuration lets us define fields to perform an ilike against when the user searches in the table view. But with vector search becoming increasingly popular these days thanks to the AI providers offering embeddings we've found a use-case for a custom search implementation, or even if we just wanted to provide FTS rather than ilike.

It would be great if devs could provide an async listSearchFilterOptions(props: { search: string }): Where | Promise<Where> that takes the search input and returns the where-clause for Payload to apply to the records. That way I could run an embeddings/FTS that returns the IDs of the documents that match and return { where: { id: { in: ids } } }.

Ideally we could also provide a listSearchPlaceholder to update the placeholder from "Search by..." to "Search" or "Semantic Search" or whatever makes sense.