Laravel Query Builder result using join() query

Question

The following query works fine, but the problem is that it gives the id of the events table instead of tasks table id in the output result.

Task::join('events', function ($join) {
    $join->on('events.task_id', '=', 'tasks.id')
        ->where('events.event_type', '=', 'Task')
        ->where('events.task_stage', '!=', 'assigned');
})->select('tasks.*')
->get();

this one duplicate

Gowthaman D
– Gowthaman D

2019-06-18 06:04:43 +00:00
Commented Jun 18, 2019 at 6:04 — Gowthaman D
– Gowthaman D, Commented Jun 18, 2019 at 6:04

Jignesh Joisar · Accepted Answer · 2019-06-18 05:55:54Z

2

Try this, one should work

->select('*', 'tasks.id as taskID')->get();

This is because maybe both tasks and events table have id field. So u need to use a separate query to specify the id.

edited Jun 18, 2019 at 5:55

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

answered Jun 18, 2019 at 5:49

Julius Fasema

9126 silver badges13 bronze badges

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

Comments

Jignesh Joisar · Accepted Answer · 2019-06-18 05:50:38Z

2

try this one

use mysql alias here

Task::join('events', function ($join) {
        $join->on('events.task_id', '=', 'tasks.id')
            ->where('events.event_type', '=', 'Task')
            ->where('events.task_stage', '!=', 'assigned');
 })->select('tasks.*','tasks.id as taskId')->get();

answered Jun 18, 2019 at 5:50

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

Collectives™ on Stack Overflow

Laravel Query Builder result using join() query

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related