Level 122
all ok if you just retrieve it as it is?
You could create a cast in the eloquent model?
Jul 28, 2020
6
Level 11
Select Statement column cast string to integer
Hi Mates, I'm in a scenario where I need to cast from string to integer in Select statement. I tried a couple of ways but it didn't work out for me. any help/suggestion that would be great. TIA
$students = Student::select([
'id',
'name',
'year',
'subjects->subject5_number as subject5_number'
])
->where('year', 2019)
->orderBy('subject5_number')->get();
Level 11
@snapey here subjects is the JSON type column in DB. I just wanna return subject5_number is an integer. I have added casts attribute to the model like this
protected $casts = ['subject5_number' => 'integer'];
but still, I'm getting value as string type.
Level 122
not sure how you can just cast it to an integer when its a json object?
1 like
Level 50
Maybe a custom accessor?
https://laravel.com/docs/7.x/eloquent-mutators#defining-an-accessor
// Student Model
protected $appends = [
'subject5_number',
];
public function getSubject5NumberAttribute() {
return (int) $this->subjects->subject5_number;
}
Level 11
@jbloomstrom so I wanna use that accessor but still, I'm getting a string type in response
Level 11
@JeffreyWay any help on this? TIA.
Please or to participate in this conversation.