I unable to fetch list that I am filtering before fetch

[NeguinhoAdmin]

Hi,

I am trying to fetch all motorbikes where('vehicle_profile_id', 2); But the filter not works.

Maybe it is pre-fetch or post-fetch issue?

<?php

namespace App\Models;

use Backpack\CRUD\app\Models\Traits\CrudTrait;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class MotorbikeCatB extends Model
{
    use CrudTrait;
    use HasFactory;
    protected $fillable = ['motorbike_id', 'notes', 'dop', 'branch_id'];
    protected $table = 'motorbikes_cat_b';
    protected $casts = [
        'dop' => 'date'
    ];

    public function branch()
    {
        return $this->belongsTo(Branch::class, 'branch_id');
    }

    public function motorbike()
    {
        return $this->belongsTo(Motorbike::class, 'motorbike_id');
    }
}

protected function setupCreateOperation()
 {
     CRUD::setValidation(MotorbikeCatBRequest::class);
     CRUD::setFromDb();

     CRUD::field('motorbike_id')->ajax(true)->minimum_input_length(0)->inline_create(true);

     CRUD::addField([
         'name' => 'motorbike_id',
         'label' => 'Motorbike',
         'type' => 'select2',
         'entity' => 'motorbike',
         'attribute' => 'reg_no',
         'model' => Motorbike::class,
         'ajax' => true,
         'inline_create' => true,
         'query' => function ($query) {
             \Log::info('Adjusting query for motorbike_id field.');
             return $query->where('vehicle_profile_id', 2);
         }
     ]);

}
 public function fetchMotorbike()
 {
     return $this->fetch([
         'model' => Motorbike::class,
         'query' => function ($model) {
             return $model->where('vehicle_profile_id', 2);
         },
         'searchable_attributes' => ['reg_no']
     ]);
 }

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Backpack\CRUD\app\Models\Traits\CrudTrait;

class Motorbike extends Model
{

    use CrudTrait;
    use HasFactory;
    // use SoftDeletes;

    protected $fillable = [
        'vin_number',
        'model',
        'reg_no',
        'vehicle_profile_id',
    ];

    protected $primaryKey = 'id';

    public static function getMotorbikeIdByRegNo($reg_no)
    {
        return Motorbike::where('reg_no', $reg_no)->first()->id;
    }

    public static function getMotorbikeModelById($id)
    {
        return Motorbike::where('id', $id)->first()->model;
    }

    protected $casts = [
        'marked_for_export' => 'integer',
    ];

    protected $hidden = ['deleted_at'];

    public function registrations()
    {
        return $this->hasMany(MotorbikeRegistration::class);
    }

    public function motorbikeCatB()
    {
        return $this->hasMany(MotorbikeCatB::class);
    }

    public function scopeExternal($query)
    {
        \Log::info('External scope called');
        return $query->where('vehicle_profile_id', 2);
    }

    public function getFilteredRegNoAttribute()
    {
        \Log::info('getFilteredRegNoAttribute called');
        if ($this->vehicle_profile_id == 2) {
            return $this->reg_no;
        }
        return null;
    }
    //
}

[NeguinhoAdmin]

solved