Why laravel returns an empty array for a has many relationship?

Question

I am using jenssegers/laravel-mongodb and i have schema is like below

Ticket Collection :

{
      "_id": ObjectId("5f32d9bb486e94459b6531c3"),
      "subject": "\"URGENT\" Non-Compliance In (Eastern Region)",
      "content": "abc",
      "user_team": "5f044199e40dfe4847056785",
      "team_ids": [
        "5f3012bbb7c2bc422e4da5a2"
      ],
      "organization_id": "5f74359c7dcc8f6fbb2b47e2"
}

Team Collection :

{
      "_id":ObjectId("5f3012bbb7c2bc422e4da5a2"),
      "name": "Medical Maintenance",
      "createTickets": true
}

Relationship in Ticket Model :

public function teams()
    {
         return $this->HasMany('App\Team', 'team_ids');
    }

Relationship in Team Model :

public function ticket()
    {
        return $this->belongsTo('App\Ticket');
    }

I am facing an issue to get data for teams relationship. It return an emtpry array.

Laravel version is 6.2 jenssegers/mongodb version is 3.6

I am not sure but have your tried `return $this->HasMany('App\Team', 'team_ids', '_id');` — Jayant, May 30 '21 at 15:07
You defined the relationship completely wrong! How the Eloquent can find tickets by `team_ids` which is multiple and defined in an array structure? — Mahdi Jedari, May 30 '21 at 15:16

score 1 · Accepted Answer · answered May 30 '21 at 19:52

1

Your approach to the foreign key is wrong, when in the context of hasMany. Instead a single column called team_id should be on the ticket and then you can do the following.

public function teams()
{
     return $this->HasMany('App\Team', 'team_id');
}

Which would work if your ticket looks like so.

{
      "_id": ObjectId("5f32d9bb486e94459b6531c3"),
      "subject": "\"URGENT\" Non-Compliance In (Eastern Region)",
      "content": "abc",
      "user_team": "5f044199e40dfe4847056785",
      "team_id":"5f3012bbb7c2bc422e4da5a2"
      "organization_id": "5f74359c7dcc8f6fbb2b47e2"
}

Instead it looks like you are actually doing a many to many, because one team can have many tickets and reverse. This can be defined like so, this will probably add the data to both models, but I'm not an expert on Mongodb in Laravel.

public function teams()
{
    return $this->belongsToMany(
        Team::class, null, 'ticket_ids', 'team_ids'
    );
}

You can find all of this in the documentation.

answered May 30 '21 at 19:52

mrhn

17,961
4
27
46

i have more than 1 million tickets, if i store ticket_id in team collection then it will be huge single document of teams and i don't thinks so it is better approach, what you say? – hu7sy May 31 '21 at 07:37
It will be the same either way? but read the last part of the ticket. – mrhn May 31 '21 at 08:04
no i have millions of ticket but team are few like 100 or 200 – hu7sy May 31 '21 at 08:13
what do you mean by "last part of ticket" ? – hu7sy May 31 '21 at 08:13
1

Last part of my answer, you can use that belongsToMany approach. That is how you designed it and that should work. Secondly i would never worry about foreign keys taking to much space. Unless they are unnecessary. – mrhn May 31 '21 at 08:29
yeah i have already tries this approach and it is working and thanks for you detail answer brother .I really appreciate. – hu7sy May 31 '21 at 08:47

score 0 · Answer 2 · answered May 30 '21 at 19:57

0

You could specify foreign and local keys.

Example:

public function teams()
{
    $this->hasMany('App\Team', 'team_ids', '_id')
}

answered May 30 '21 at 19:57

Taylan

1
1

i specify but it still return an emtpy – hu7sy May 31 '21 at 07:39

Why laravel returns an empty array for a has many relationship?

2 Answers2

Linked