Relations search about plastic HOT 3 CLOSED

You can just normalize your data on index time using the buildDocument method:

class Activity {

    use Searchable;

    public function buildDocument()
    {
        return $this->load('user')->toArray();
    }

    public function user()
    {
        return $this->hasOne('App\User');
    }
}

Then your document in elastic will look like:

{
  id: 1,
  name: "My activity",
  user: {
    id: 1,
    name: "joe",
    email: "[email protected]"
    ...
  }
}

and you can search like this:
Activity::search()->filter()->term('user.name', 'joe');

I would use a nested document for users, so you have to adjust your mapping:

$map->nested('user', function (Blueprint $map) {
    $map->string('id');
    $map->string('name');
    $map->string('email');
});

Query will then look like

Activity::search()->nested('user', function (SearchBuilder $builder) use ($term) {
    $builder->match('user.name', $term);
});

from plastic.

Hi @mschreck and thanks for the answer.

The first part is working perfect.

I`ve decided to try with the nested query and mapping but it isn't working.

Is there anything special that I should do when I want to use the nested queries?

from plastic.

@belov91 nested queries needs special mappings for instance in your Activity model mapping you need something like this.

$map->nested('user', function (Blueprint $blueprint) {
              
   $blueprint->integer('id');

   $blueprint->string('name', [
          'store'    => 'true',
          'index'    => 'analyzed',
          'analyzer' => 'english',
    ]);

    //...
});

ll reopen the issue if needed

from plastic.