sorting record of a model based on attribute of associated model in ruby on rails

Question

I have a stock model and supply model and stock belongs to supply model.

I want to sort stock records based on "date_received" attribute of supply model

Stock.where("seller_id = ? AND status = ? AND product_id = ?", @seller_id, "Approved", list_item.product_id)

I am getting error for below:

Stock.includes(:supply).where("seller_id = ? AND status = ? AND product_id = ?", @seller_id, "Approved", list_item.product_id).order("supply.date_received")

it should be table name in order clause like supplies

LHH
– LHH

2019-05-14 12:11:24 +00:00
Commented May 14, 2019 at 12:11 — LHH
– LHH, Commented May 14, 2019 at 12:11

Vishal · Accepted Answer · 2019-05-14 12:48:08Z

2

there just should be supplies instead of supply Try,

Stock.includes(:supply).where("seller_id = ? AND status = ? AND product_id = ?", @seller_id, "Approved", list_item.product_id).order("supplies.date_received")

edited May 14, 2019 at 12:48

answered May 14, 2019 at 12:12

Vishal

8288 silver badges20 bronze badges

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

3 Comments

Bhimasen Rautaray Over a year ago

I am getting this error: PG::AmbiguousColumn: ERROR: column reference "seller_id" is ambiguous LINE 1: ... ON "supplies"."id" = "stocks"."supply_id" WHERE (seller_id ...

Jasjeet Singh Over a year ago

you must have seller_id in both tables. stocks.seller_id will solve your problem.

Vishal Over a year ago

@BhimasenRautaray use table name with column name in where clause query like "stocks.seller_id = ?" this will resolve the exception

Collectives™ on Stack Overflow

sorting record of a model based on attribute of associated model in ruby on rails

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related