Query Rails Postgres with array data type

Question

So, Ive been trying to query my PostgreSQL model in Rails, but get the following error:

undefined method `id' for TransactionTemplate::ActiveRecord_Relation

My code:

    @transaction_templates = TransactionTemplate.where("transaction_category_id = 1")
    @transaction = Transaction.where("transaction_template_id in (?)", @transaction_templates.id)

I know that the transaction templates is an array and that there is therefor not just one ID it needs to look up, but multiple of IDs, just as I want it.

Any suggestions?

dp7 · Accepted Answer · 2016-05-05 09:08:52Z

2

Try this:

@transaction_templates = TransactionTemplate.where("transaction_category_id = 1")
@transaction = Transaction.where("transaction_template_id in (?)", @transaction_templates.map(&:id))

answered May 5, 2016 at 9:08

dp7

6,7491 gold badge23 silver badges38 bronze badges

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

Comments

Thorin · Accepted Answer · 2016-05-05 09:18:37Z

0

If you need just ids then try:

@transaction_template_ids = TransactionTemplate.where("transaction_category_id = 1").pluck(:id)
@transaction = Transaction.where("transaction_template_id in (?)", @transaction_template_ids)

Or you have proper associations then

@transaction = Transaction.joins(:transaction_template).where("transaction_category_id = 1")

edited May 5, 2016 at 9:18

answered May 5, 2016 at 9:15

Thorin

2,0341 gold badge19 silver badges30 bronze badges

1 Comment

doer123456789 Over a year ago

Thanks Ansar, used dkp's answer though

Collectives™ on Stack Overflow

Query Rails Postgres with array data type

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related