A select in rails query does not return an array

Question

Here is the rails 3 query in the app:

Order.where('id IN (?)',ContractItem.where(contract_id: @contract.id).select('contract_item_id'))

Here is the only record in contract_item table:

enter image description here

As shown in the record, the @contract.id is equal to 1 and we expect ContractItem.where(contract_id: @contract.id).select('contract_item_id') returns array [2]. So Order.where('id IN (?)',ContractItem.where(contract_id: @contract.id).select('contract_item_id'))should return order#2. However what we have got is nothing. We figure an empty array must be returned instead. Is there something wrong with the code above?

SteveTurczyn · Accepted Answer · 2014-08-01 22:49:00Z

2

You're getting back an array, but it's an array of ContractItem objects with a single column, not an array of numbers.

Try instead...

Order.where('id IN (?)',ContractItem.where(contract_id: @contract.id).pluck(:contract_item_id))

edited Aug 1, 2014 at 22:49

answered Aug 1, 2014 at 22:43

SteveTurczyn

37k6 gold badges46 silver badges56 bronze badges

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

3 Comments

Eyeslandic Over a year ago

Or use pluck method, ContractItem.where(contract_id: @contract.id).pluck(:contract_item_id)

SteveTurczyn Over a year ago

Yes, @Iceman good point! Don't need to return the whole record. I'll modify my answer.

user938363 Over a year ago

Here is an article about pluck and select. rubyinrails.com/2014/06/rails-pluck-vs-select-map-collect

Collectives™ on Stack Overflow

A select in rails query does not return an array

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