Get only one column and create an alias for that column using "with()" function in laravel

Question

I have two tables, JobOrder and Job. I'm using one-to-many relationship.

One Job can have many JobOrder and one JobOrder belongs to only one Job.

JobOrder Model:

public function job()
{
    return $this->belongsTo(Job::class);
}

Controller:

public function getAllJobOrder()
{
    $results = JobOrder::with('job')->get();
    return $results;
}

the code above returns data like this:

I want to get only the job->position and create an alias just like this:

I can actually achieve the return in the above image using withCount but I don't think it is the right way to do it.

public function getAllJobOrder()
{
    $results = JobOrder::withCount(['job AS position' => function ($q) {
            $q->select('position');
        }])->get();
    return $results;
}

Is there any other way than using withCount?

If you want to always select single column then add select('position') with your relationship. — Nikhil Vaghela
– Nikhil Vaghela, Commented Jan 24, 2019 at 6:57
correct me if I'm wrong, using select requires the id column. which means it would return 2 columns. — Kapitan Teemo
– Kapitan Teemo, Commented Jan 24, 2019 at 6:59

Jinal Somaiya · Accepted Answer · 2019-01-24 06:43:38Z

2

try this:

controller

public function getAllJobOrder()
{
    $results = JobOrder::with('job')->get();
    foreach($results as $result){
       $result->position = $result->job->position;
       unset($result->job);
    } 
    return $results;
}

answered Jan 24, 2019 at 6:43

Jinal Somaiya

1,99117 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get only one column and create an alias for that column using "with()" function in laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related