How to add a field to search index

Hej,

under https://oroinc.com/orocrm/doc/current/book/search it’s written that you can modify the indexed fields, by editing a bundles search.yml’s field section.

YAML

OroCRM\Bundle\MagentoBundle\Entity\Order: ... fields: ... - name: customer_id target_type: integer target_fields: [customer_id]

1 2 3 4 5 6 7 8

OroCRM\Bundle\MagentoBundle\Entity\Order: ... fields: ...    -             name:                   customer_id             target_type:            integer             target_fields:          [customer_id]

After clearing the cache, and reindexing it with

PHP

php ./app/console oro:search:reindex

1	php  ./app/console oro:search:reindex

, the field doesn’t appear to be indexed in the oro_search_index tables.

What else do I have to do, to index a new field for search?

Thank you.

Using OROCRM 1.10.13

Topic

[ahrrikisParticipant]

As far I figured out, its working, but not with reindexing.

Now following is added to search.yml

YAML

- name: customerEmail target_type: text target_fields: [customer_email]

1 2 3 4

-             name:                   customerEmail             target_type:            text             target_fields:          [customer_email]

[Mike KudelyaParticipant]

Hi

Please add id column to customer relation section (in search.yml), add to customer entity getId() function, clear cache and run reindex command:

YAML

name: customer relation_type: many-to-one relation_fields: - name: id target_type: text target_fields: [customerId]

1 2 3 4 5 6 7

name:                   customer             relation_type:          many-to-one             relation_fields:                 -                     name:                   id                     target_type:            text                     target_fields:          [customerId]

To get more strict search, please read my post about it.

[ahrrikisParticipant]

Thank you for your reply.

Unfortunately thats not resolving the problem, finally I wanted to add the customer_email field of the orders-table to the index.
It’s working for all new synced orders, but its not working during index, so the problem is not to add the field, the problem is how to add the field so that is in the index after the reindex.

The problem of token length and the reindex field I am aware of. Unfortunately that also reduceds the precision of the result using an email-address.

With php and oro I didn’t figure out the solution. I added the field with a sql job to the index, as solution to enlage the precision and reduce the recall, we just skipped every token that causes tokenization in mysql fulltext search.

[Mike KudelyaParticipant]

I’m not really understand why your index doesn’t appear in oro_search_index_* tables after reindex. I have tried add customer id to index and after reindex i found it in oro_search_index_text

[Author]

Replies