Searching on Related Entities

Hi there. I’m trying to create a select/create inline form type for contact addresses and I’ve mostly had some good success with it. However, I need the search to limit the results it gets on addresses for a particular contact. The issue I have it that no matter what I do, I can’t seem to get the information for the contact into the search index.

So here’s my search.yml:

YAML

OroCRM\Bundle\ContactBundle\Entity\ContactAddress: alias: orocrm_contact_address label: orocrm.contact_address.entity_plural_label route: name: orocrm_contact_index # parameters: # id: owner.id search_template: BundleName:searchResult.html.twig fields: - name: namePrefix target_type: text target_fields: [namePrefix] - name: firstName target_type: text target_fields: [firstName] - name: middleName target_type: text target_fields: [middleName] - name: lastName target_type: text target_fields: [lastName] - name: nameSuffix target_type: text target_fields: [nameSuffix] - name: label target_type: text target_fields: [label] - name: street target_type: text target_fields: [street] - name: street2 target_type: text target_fields: [street2] - name: postalCode target_type: text target_fields: [postalCode] - name: owner relation_type: many-to-one relation_fields: - name: id target_type: integer target_fields: [ownerId]

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53

OroCRM\Bundle\ContactBundle\Entity\ContactAddress:     alias:                          orocrm_contact_address     label:                          orocrm.contact_address.entity_plural_label     route:         name:                       orocrm_contact_index         # parameters:         #     id:                     owner.id     search_template:                BundleName:searchResult.html.twig     fields:         -             name:                   namePrefix             target_type:            text             target_fields:          [namePrefix]         -             name:                   firstName             target_type:            text             target_fields:          [firstName]         -             name:                   middleName             target_type:            text             target_fields:          [middleName]         -             name:                   lastName             target_type:            text             target_fields:          [lastName]         -             name:                   nameSuffix             target_type:            text             target_fields:          [nameSuffix]         -             name:                   label             target_type:            text             target_fields:          [label]         -             name:                   street             target_type:            text             target_fields:          [street]         -             name:                   street2             target_type:            text             target_fields:          [street2]         -             name:                   postalCode             target_type:            text             target_fields:          [postalCode]         -             name: owner             relation_type: many-to-one             relation_fields:                 -                     name: id                     target_type: integer                     target_fields: [ownerId]

My definition for the search handler:

PHP

bundle_name.form.autocomplete.contact_address.search_handler: class: %bundle_name.form.autocomplete.contact_address.search_handler.class% parent: oro_form.autocomplete.search_handler arguments: - OroCRM\Bundle\ContactBundle\Entity\ContactAddress - ["namePrefix", "firstName", "middleName", "lastName", "nameSuffix", "label", "street", "street2", "postalCode", "owner", "owner.id"] tags: - { name: oro_form.autocomplete.search_handler, alias: contact_addresses, acl_resource: orocrm_contact_view } lazy: true

1 2 3 4 5 6 7 8 9

bundle_name.form.autocomplete.contact_address.search_handler:         class: %bundle_name.form.autocomplete.contact_address.search_handler.class%         parent: oro_form.autocomplete.search_handler         arguments:             - OroCRM\Bundle\ContactBundle\Entity\ContactAddress             - ["namePrefix", "firstName", "middleName", "lastName", "nameSuffix", "label", "street", "street2", "postalCode", "owner", "owner.id"]         tags:             - { name: oro_form.autocomplete.search_handler, alias: contact_addresses, acl_resource: orocrm_contact_view }         lazy: true

With owner.id in the property definition, I get an error:

PropertyAccessor requires a graph of objects or arrays to operate on, but it found type “NULL” while trying to traverse path “owner.id” at property “id”.

And without that column, I see an empty owner object:

{ results: [ { id: 1, namePrefix: null, firstName: null, middleName: null, lastName: null, nameSuffix: null, label: "Mr John Johnson", street: "Some Stree", street2: null, postalCode: "PO CODE", owner: { __initializer__: { }, __cloner__: { }, __isInitialized__: false } } ]

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

{ results: [ { id: 1, namePrefix: null, firstName: null, middleName: null, lastName: null, nameSuffix: null, label: "Mr John Johnson", street: "Some Stree", street2: null, postalCode: "PO CODE", owner: {     __initializer__: { },     __cloner__: { },     __isInitialized__: false } } ]

Then in the search handler, I try to get the results as follows:

PHP

$query = $this->indexer->getSimpleSearchQuery($searchTerm, $firstResult, $maxResults, $this->entitySearchAlias); $query->andWhere('owner.id', '=', $contactId, 'integer');

1 2	$query = $this->indexer->getSimpleSearchQuery($searchTerm, $firstResult, $maxResults, $this->entitySearchAlias); $query->andWhere('owner.id', '=', $contactId, 'integer');

I’m having no issues getting the contact ID from the form type to the search handler, the problem seems to be that the information I’m trying to limit on isn’t in the search index itself. Can anyone explain what I’m doing wrong?

Thanks,
Simon

Topic

[Yevhen ShyshkinParticipant]

Hello.

1) PropertyAccessor requires a graph of objects or arrays to operate on, but it found type “NULL” while trying to traverse path “owner.id” at property “id”.
Please, check if your contact address has an owner – if not then this is invalid address, address always must have related contact.

2) And without that column, I see an empty owner object:
It’s not empty, it’s just not initialized proxy object. In general this is not really good idea to pass serialized object to frontend (unless you serialized them manually in search hander) – usually better to get field values via property paths (like owner.id).

3) $query->andWhere(‘owner.id’, ‘=’, $contactId, ‘integer’);
This is a query to search index, not regular DB, so you should use fields defined in search index. In this case you should use “ownerId” instead of “owner.id”. To make you life easier you can always look at real index values (e.g. ownerId might be stored in DB table oro_search_index_integer).

[archy_boldParticipant]

Thanks for the response Yevhen, that’s really helped.

Re your responses:

1) There is one address without an owner, would this break it for all the results?

2) Thanks, I understand now.

3) I tried ownerId but to no avail. I just tried it now and it worked! Maybe it hadn’t indexed properly, but I wasn’t aware of the search tables, so that will help for debugging.

[Yevhen ShyshkinParticipant]

> There is one address without an owner, would this break it for all the results?
Well, even one address without owner is invalid. Despite that, you’ll probably never receive it because you are filtering by owner and it means that owner exists. Still, you can override that method in your handler and catch these exceptions.

[archy_boldParticipant]

It’s not really a problem as long as I don’t pass the related info to the search handler. Cool, cheers for the info.

[Author]

Replies