Best way to implement fulltext search on a collection?

Raigatolast year

3 1

• Selected Answer
  

  pooledgelast year

  Just came back to it. So far it works for me with a named index created on server (re)start:

  const start = async () => {
  	// ...somewhere after payload itself has been initialized
  
  	payload.db.collections['items'].schema.index(
  		{ title: 'text', description: 'text' },
  		{
  			name: 'fulltext_1',
  			...
  		}
  	)
  }
• 

  pooledgelast year

  I am not sure whether this is the best way, but, after creating an index I've simply added an endpoint within server.ts to perform a text search, and it seems working:

  app.get('/search', async (req, res) => {
  	const query = `${req.query.q}` || '';
  
  	const results = await payload.db.collections['items'].find({
  		$text: { $search: query },
  	});
  
  	res.json({ results });
  });

  https://payloadcms.com/docs/database/mongodb#access-to-mongoose-models

  3 replies
  

  Raigatolast year

  Thank you @pooledge, did you created the $text index manually or added it somewhere in your codebase?
  Doing it manually might be an issue for me as I work with PR staging environments creating a new db every time

  

  pooledgelast year

  Just came back to it. So far it works for me with a named index created on server (re)start:

  const start = async () => {
  	// ...somewhere after payload itself has been initialized
  
  	payload.db.collections['items'].schema.index(
  		{ title: 'text', description: 'text' },
  		{
  			name: 'fulltext_1',
  			...
  		}
  	)
  }

  

  deep-12418 months ago

  payload.db.collections['items'].schema.index(
  { title: 'text', description: 'text' },
  )

  Below error is coming when trying to implement this:
  Property 'collections' does not exist on type 'DatabaseAdapter'