Laravel how to get values from a table with an id from another table

just a quick pointer, a relation that is belongsTo is a singular relationship so the relationship name should be singular also, e.g. taskinteraction belongs to task and not tasks

to your query

$tasks = $user->tasks()->whereHas('taskinteractions', function ($query) {
    $query->where('status', 'In Progress');
})-with('taskinteractions')->get();

@Snapey .

Using your solution i get the following error: "Undefined variable: user".

I have tried different approaches to this problem, until now I have no good results. I believe the following approach is the easier one. Start by getting the task_id's where status is equal to the desired status. Then, use those task_id's to get the task data.

$inprogress = Taskinteraction::where('status','=','Unassigned')->get();

Echo $inprogress will return a collection, like this this:

[{"id":6,"task_id":47,"status":"Unassigned","comments":null,"created_at":"2017-04-28 13:18:13"},{"id":7,"task_id":48,"status":"Unassigned","comments":null,"created_at":"2017-04-28 13:20:09"},{"id":8,"task_id":49,"status":"Unassigned","comments":null,"created_at":"2017-04-28 13:24:38"}]

But, I only need the task_id, to be correct I only need an array of task_id’s to use in something like this:

$tasksinprogress = Task::where('assigned_to','=',auth::id())->whereIn('id', $inprogress)->get();

How do I extract the task_id property from this array of objects?

Another question: How do i query the table task_interactions to get the same result as the following query:

SELECT task_id FROM schema.task_interactions WHERE status = 'Unassigned';

sorry but i assumed you would at least have the skills to work out that $user represents the user who's tasks your are trying to get.

Ok, I'll try it later. I am not a developer, this is my first experience in coding and it only started one month ago. I'm discovering laravel and sometimes I see explanations that I assume are using plain code and not some of the framework's features. Thanks a lot for your help

Sorry, did not mean to put you down. If you see something like that 'undefined' you need to think what was intended, where could the missing variable come from?

If you are getting tasks for the current user then you can initialise the $user with $user = Auth::user(); which gets the authenticated user, but if you only need the variable once ($user in this case), you can skip creating it and chain off the function.

So, the method I suggested could be changed to;

$tasks = Auth::user()->tasks()->whereHas('taskinteractions', function ($query) {
    $query->where('status', 'In Progress');
})-with('taskinteractions')->get();

... gets the tasks for the current user, but only the tasks that are 'In Progress'

It's fine, i didn't take it that way. I just thought i should explain that i have little experience and so my questions might sound a bit dumb. Communication can be difficult when there's a big gap between the both ends.

I have tried your solution, and got an error, but i think this time it might be a design error. in my tasks table i am not using user_id, i am using a created_by and an assigned_to columns. The error says:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tasks.user_id' in 'where clause' (SQL: select * from `tasks` where `tasks`.`user_id` = 4 and `tasks`.`user_id` is not null and exists (select * from `task_interactions` where `tasks`.`id` = `task_interactions`.`task_id` and `status` = In Progress))

The query is looking for an user_id

so when you define the relationship, something like belongTo uses convention to decide what the foreign key should be.

If you have a different name you can supply this as an additional parameter to the relationship

Thanks a lot! Made a simple test and it's working... Also, thanks for the way you've answered the question, you could have give me the code, but no... you just gave me enough information to guide me. And I've learned something. :)

i have changed the method Tasks in the model User to this:

    public function Tasks()
    {
        return $this->hasMany('App\Task','assigned_to');
    }