Laravel Custom Query

Question

I have this query

SELECT ANY_VALUE(id) as id, title FROM `major` where university_id=1 group BY `title` order by id asc

I want to convert it into Laravel Query , I have a model majors and the function as follow

public static function retrieveByUniversityIDForWeb($universityId){
    return self::select(DB::raw('ANY_VALUE(id) as id, title'))->from('major')->where('university_id', $universityId)->orderBy('id','desc')->simplePaginate(6);
}

but its not returning me the results , query works in phpmyadmin. Any idea what I missed?

How are you accessing this method on model? Share the controller logic. — Sandeesh
– Sandeesh, Commented May 31, 2017 at 16:17

Sandeesh · Accepted Answer · 2017-05-31 16:24:24Z

1

You're declaring the method on your model which references its table by default. Also there's no need for using ANY_VALUE in your query. If you need it for some reason then you can change the select below to selectRaw('ANY_VALUE(id) as id, title')

public static function retrieveByUniversityIDForWeb($universityId)
{
    return self::select('id', 'title')
        ->where('university_id', $universityId)
        ->orderBy('id', 'desc')
        ->simplePaginate(6);
}

answered May 31, 2017 at 16:24

Sandeesh

12k3 gold badges35 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Laravel Custom Query

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