Ruby-On-Rails: Finding DB entry that has a certain array value

Question

I have a model TestRun that has an array entry :machine_ids that is an array of integers. How will I be able to call find with conditions so that I can find the specific TestRun entry whose field :machine_ids has a specific array entry mid and a :status "Running".

This is a rough outline of what I want. I do not know how to format the conditions for finding if the array contains mid.

cur_testrun = TestRun.find(:first, :conditions => {:machine_ids => mid, :status => "Running"})

Community · Accepted Answer · 2017-05-23 10:33:29Z

0

The array will serialize into YAML for storage in your database. Serialized data doesn't lend itself to easy or efficient querying.

As suggested in the question & answer below, you could try normalize the schema a little. Alternatively you're left with the SQL 'like' query which won't be fun to write if your matching gets complex.

Rails active record query, serialized array

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Aug 1, 2012 at 19:42

Gazza

3,1511 gold badge22 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Ruby-On-Rails: Finding DB entry that has a certain array value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related