Eloquent query doesn't return the right answer

I am trying to bring only some of the stations, but I can't seem to be using the query right. If i put it as query()->$results it says

Array to string conversion and this way it just returns all the stations

 public function builder()
    {
        $results = DB::select( DB::raw("
        SELECT * 
        FROM stations
        WHERE stations.id IN(
            SELECT station_id
            FROM station_workbook
            WHERE workbook_id = ".$this->current_workbook->id."
        )
    
    ") );

    return Station::query()->$results;

    }

SilenceBringer

4 years ago

Best Answer

Level 55

@ichmag17 looks like you miss the part of code. Check and format your original post

As far as I can see - you can use whereHas https://laravel.com/docs/8.x/eloquent-relationships#querying-relationship-existence (assuming you have relationship stationWorkbooks between Station and StationWorkbook)

return Station::whereHas(fn ($query) => $query->where('workbook_id', $this->current_workbook->id))->get();

ichmag17

4 years ago

Level 1

I have updated the question and tried it and indeed now it works with your help.

Station::query()->whereHas('workbooks', fn ($query) => $query->where('workbook_id', $this->current_workbook->id));

this is what I have used in the end

Please or to participate in this conversation.