Trying to access role with user pagination not working

[umar28dec]

Not getting roles here

    $paginator = User::with('roles')->orderBy('created_on','desc')->paginate(10);

in this case not returning role.

If remove orderBy then it works (mean return data with roles)

    $paginator = User::with('roles')->paginate(10);

[erikn69]

I tried and it returns the expected result

$paginator = User::with('roles')->orderBy('created_at','desc')->paginate(10);

     #relations: array:1 [▼
          "roles" => Illuminate\Database\Eloquent\Collection {#2175 ▼
            #items: array:2 [▼
              0 => App\Models\Role {#2202 ▶}
              1 => App\Models\Role {#2205 ▶}
            ]
          }
        ]

[umar28dec]

@erikn69 is that because of column name change created_on, I am using Laravel 8

[umar28dec]

@erikn69 do you want me to post complete code ?

[erikn69]

I tried changing my db field from created_at to created_on and works the same, laravel 8

[umar28dec]

Thanks for update