Select statement set null column defualt value to 0

Hi,

I am creating a query and executing it in sqlserver. I want to set null column value to 0 in select statement using method like coalesce, isnull but it is throwing error. "can not access empty property".

any help will be much appreciated.

Thanks, Somnath

okawei

8 years ago

Level 2

So, you can add an attribute mutator in the model if all you're looking to do is return zero instead of null. Not sure if this is a solution in your case but here's how you'd do it

public function getYourColumnNameAttribute($value){
    return $value !== null ? $value : 0;
}

Just add that method to your model.

somnathsah

8 years ago

Level 3

@okawei I am not using model instance for querying. I am using DB::table() to do the query. for example I am creating a query like this.

DB::table('test')
->select(DB::raw('isnull(column, 0)'))->get();

So, isnull function is not working, My database is SQL server.

Please or to participate in this conversation.