Laravel Query Buider Group By Not Getting All The Records

Question

I am trying to get the data using groupBy on type field from my transaction table. I am using this query

DB::table($this->table)
    ->select()
    ->whereRaw($where['rawQuery'], isset($where['bindParams']) ? $where['bindParams'] : array())
    ->groupBy('type')
    ->get();

But it is not giving the complete records. There are more than 10 records in my table. But it is giving me only two. One for type=1 and another for type=2. It is selecting only on record from each type. I am expecting that i will get all the transactions based on condition grouped in two result set. Anyone know why it is happening?

i am expecting that i will get all the transactions based on condition grouped in two resultset — RAUSHAN KUMAR, Jan 12 '18 at 12:00
`based on condition grouped in two resultse` what condition ? and grouped means rows here. so you are getting right — Niklesh Raut, Jan 12 '18 at 12:02

score 3 · Accepted Answer · answered Jan 12 '18 at 12:03

3

Try to call Collection groupBy instead. Just put groupBy after get(). It should work.

DB::table($this->table)
    ->select()
    ->whereRaw($where['rawQuery'], isset($where['bindParams']) ? $where['bindParams'] : array())
    ->get()
    ->groupBy('type');

answered Jan 12 '18 at 12:03

Laerte

6,773
3
31
49

I'm glad to know it helped you! :) – Laerte Jan 12 '18 at 12:09

score -1 · Answer 2 · answered Nov 19 '18 at 12:35

-1

Faq::where('type','host')->get()->groupBy('category');

answered Nov 19 '18 at 12:35

kush

439
4
7

1

Add more to your answer than just code, because this does not explain how does it solve the problem by OP. – thefolenangel Nov 19 '18 at 12:55
funnyly this is the answer what im lookin for :D – Ricky Orlando Napitupulu Mar 26 '20 at 02:48

Laravel Query Buider Group By Not Getting All The Records

2 Answers2

Linked