PrismaP
Prisma•2y ago•
3 replies
Florian

No index found for fulltext search over relation (Planetscale)

I'm trying to find "favorited companions" combined with the ability to search through them.

As you can see in my code, I search inside a relation query. But I get an error that no index could be found.

Is this not possible with Planetscale?

Searching throug companions directly works. The search index on name + description exists. But I don't know what index I could add to the favorites model to make this work.

const results = await prismadb.favorite.findMany({
  where: {
    userId: user.id,
    ...(query && {
      OR: [
        {
          companion: {
            name: {
              search: `${query}*`,
            },
          },
        },
        {
          companion: {
            description: {
              search: `${query}*`,
            },
          },
        },
      ],
    }),
  },
  include: {
    companion: {
      include: {
        favorites: true,
      },
    },
  },
});
Was this page helpful?