How to Set Foreign Key For hasMany Relationship? Please I really need help.

[JenuelDev]

So I have this table

// table name: coz_lessons_changes { "_id": ObjectId("5fdd41cfc8c832ba57cdb3a6"), "lesson_id": ObjectId("5fd84e467f180d5db02be90f"), "to_status": "booking" }

and I have another table

// table name: coz_lessons { "_id": ObjectId("5fd84e467f180d5db02be90f"), "student_uid": NumberInt("3151989"), "activated": true, }

coz_lessons is the main table, and the coz_lessons_changes has a field called lesson_id which is the foreign key from coz_lessons.

how to set the function here so that it will know what to get,
bellow is my initial code but cant make it work.

<?php namespace App\Models\CozLesson; use Jenssegers\Mongodb\Eloquent\Model as Eloquent; class CozLesson extends Eloquent { protected $connection = 'utalk_server'; //need to set the connection protected $collection = 'coz_lessons'; //pangalan ng table public function coz_lesson_changes() { return $this->hasMany(CozLessonChanges::class,'lesson_id','_id'); } public function getLessonChanges($request) { $lesson = CozLesson::find($request->input('id')); $data = $lesson->coz_lesson_changes()->get(); return $data; } }

[divine]

Hello,

Try changing "lesson_id": ObjectId("5fd84e467f180d5db02be90f") to string type "lesson_id": "5fd84e467f180d5db02be90f"

Thanks!

[JenuelDev]

oh yeah, the problem, other team generated it but our team has to get it even if it's as object id. Is there any alternative besides converting to a string? Thanks 😊

[divine]

oh yeah, the problem, other team generated it but our team has to get it even if it's as object id. Is there any alternative besides converting to a string? Thanks 😊

It's actually a bug, however, fixing it will be a breaking change for existing applications so it's basically being delayed.

Keep in mind that this library doesn't correctly use ObjectIds. I don't know what the solution might be...

Thanks!

[JenuelDev]

oh thanks..

[divine]

oh thanks..

If you'd like to understand the problems just have a read #1974 (comment)

Thanks!