doctrine / mongodb-odm

The Official PHP MongoDB ORM/ODM
https://www.doctrine-project.org/projects/doctrine-mongodb-odm/en/latest/
MIT License
1.09k stars 502 forks source link

Document working with text indexes #2051

Open alcaeus opened 5 years ago

alcaeus commented 5 years ago

Feature Request

Q A
New Feature no
RFC no
BC Break no

Summary

The index section in the docs does not contain any information on how to work with text indexes. While the query builder docs have a section on text search (see https://www.doctrine-project.org/projects/doctrine-mongodb-odm/en/1.2/reference/query-builder-api.html#text-search), it would be beneficial to also document creating text indexes along with the various options that are possible for them.

malarzm commented 4 years ago

This just popped up on SO: https://stackoverflow.com/questions/61933036/error-text-index-required-for-text-query

shubaivan commented 4 years ago

@alcaeus I faced with error about language. I use db version v4.4.0

I added index to my collection

/**
 * @MongoDB\Document(repositoryClass=AwinProductRepository::class)
 * @MongoDB\Index(keys={"product_name"="text"})
 */
class AwinProduct extends AbstractDocument
{
    /**
     * @MongoDB\Field(type="string")
     */
    protected $aw_deep_link;

    /**
     * @MongoDB\Field(type="string")
     */
    protected $product_name;

and then try to update schema

/var/www/symfony # php bin/console doctrine:mongodb:schema:update
Index build failed: 201968ff-ee54-456e-afc1-6ed742906343: Collection symfony.AwinProduct ( 71eb1888-9850-4799-889b-2d5908bcab46 ) :: caused by :: language override unsupported: 
/var/www/symfony # 

in native query I faced with the same problem

db.getCollection('AwinProduct').createIndex( { product_name: "text", aw_product_id: "text" } )

Index build failed: 024ff5ce-07fc-493f-be0f-bc21b8c28cfe: Collection symfony.AwinProduct ( 71eb1888-9850-4799-889b-2d5908bcab46 ) :: caused by :: language override unsupported:

hm, some advice ?

nixilla commented 2 years ago

This just popped up on SO: https://stackoverflow.com/questions/61933036/error-text-index-required-for-text-query

I've answered this question on SO, if you still need it.

malarzm commented 2 years ago

@nixilla cool! Would you mind contributing to our documentation as well?