Best way to implement fulltext search on a collection?

Raigato8 months ago

3 1

• Selected Answer
  

  pooledge7 months ago

  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',
  			...
  		}
  	)
  }
• 

  pooledge8 months ago

  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

  2 replies
  

  Raigato7 months ago

  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

  

  pooledge7 months ago

  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',
  			...
  		}
  	)
  }