how access through relationship value using select field

[christmex]

Hi guys, I have a question, so let say I have this table

classrooms
- id
- classroom_name

schools
- id
- school_name

school_classroom_configs
- id
- school_id
- classroom_id

classroom_configs
- school_classroom_config_id

What I want

• I want to access and show the classroom_name from classrooms table inside the select field in my classroom_config create page

What have I done

//inside my setupCreateOperation in ClassroomConfigsCrudController
CRUD::addfield([  
    'label'     => "Kelas",
    'type'      => 'select',
    'name'      => 'school_classroom_config_id',
    'entity'    => 'SchoolClassroomConfig',
    'model'     => "App\Models\SchoolClassroomConfig",
    'attribute' => 'classroom',
    'allows_null'     => false,
    'options'   => (function ($query) use($schoolId) {
        $query = $query->with('Classroom')->whereIn('school_id', $schoolId)->get();
        return($query);
    }),
]);

also, i defined the relationship inside my model

    public function SchoolClassroomConfig()
    {
        return $this->belongsTo('App\Models\SchoolClassroomConfig', 'school_classroom_config_id');
    }

and inside the SchoolClassroomConfig there is relationship to classrooms table

but it shows

I don't know how to access the data when it shows this value, I have tried to set my 'attribute' => 'classroom.classroom_name' or 'attribute'=>'classroom->classroom_name' etc but it still doesn't work.
I also think that I can perform something like this

CRUD::addfield([  
    'label'     => "Kelas",
    'type'      => 'select',
    'name'      => 'school_classroom_config_id',
    'entity'    => 'SchoolClassroomConfig.Classroom',
    'model'     => "App\Models\SchoolClassroomConfig",
    'attribute' => 'classroom_name',
]);

but it doesn't work, it works only in setupListOpertion which we change the addField to addColumn when we use it in setupListOpertion

is there a better way to achieve this? or should I create a new custom field? let me know if you have another detail

thanks 🙏

[christmex]

Hi, i decide to manipulate the data inside options key, so it look like this

CRUD::addfield([  
    'label'     => "Kelas",
    'type'      => 'select',
    'name'      => 'school_classroom_config_id',
    'entity'    => 'SchoolClassroomConfig',
    'model'     => "App\Models\SchoolClassroomConfig",
    'attribute' => 'classroom',
    'allows_null'     => false,
    'options'   => (function ($query) use($schoolId) {
        $query = $query->with('classroom')->whereIn('school_id', $schoolId)->get();
          foreach ($query as $key => $value) {
              $value->classroom_name = $value->classroom->classroom_name;
          }
          return($query);
    }),
]);

then I achieve what I want, they key still using the school_classroom_config id, and I have access to classroom_name from classrooms table.

thanks guys 🙏

[christmex]

If you guys still have another option, I'm open to it, thanks