search

sunel / eav

Entity–attribute–value model (EAV) for Laravel Artisan
https://sunel.github.io/eav/
143 stars 39 forks source link

paginate problem #64

Open smilelanss opened 2 years ago

smilelanss commented 2 years ago

Hi again @sunel. Problem pagination $products = ProductEav::select(['attr.*'])/*->groupBy('rating_attr.value', 'products.id')*/->paginate(20);

solved by adding to the request groupBy('rating_attr.value', 'products.id')

sunel commented 2 years ago

@smilelanss

What is the issue here, sorry i am unable to understand above

smilelanss commented 2 years ago

$products = ProductEav::select(['attr.'])/->groupBy('rating_attr.value', 'products.id')*/->paginate(20);

I do $products = ProductEav::select(['attr.*'])->paginate(20); And I have error

SQLSTATE[42803]: Grouping error: 7 ERROR: column "rating_attr.value" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...d" and "rating_attr"."attribute_id" = $1 order by "rating_at... ^ (SQL: select count(*) as aggregate from "products" inner join "product_float" as "rating_attr" on "products"."id" = "rating_attr"."entity_id" and "rating_attr"."attribute_id" = 122 order by "rating_attr"."value" desc)