Query column of arrays with array

Question

I have a database column with the datatype array. How can I query an array with an array in rails? For example, I have an array of software for an OS in my Product table and I want to query them like this:

selected_products = ['Apple', 'Linux']

Software.where("'#{selected_products}' = ANY (osses)")

edit:

example of Software table:

id  |  software    |        osses         |
_______________________________________________________

1     product 1     {'Windows', 'Apple', 'Android'}
2     product 2     {'Android', 'Linux'}
3     product 3     {'Windows,', 'Android'}
4     product 4     {'Windows'}

In which case I'd like the query to return id's 1 and 2 (since id 1 has a match in Apple and id 2 has a match in Linux.)

Can you give us a concrete example (eg what the data would look like in the table and what you'd pass to it and what the result would like like - if you were god and could make it however you like? :) — Taryn East
– Taryn East, Commented Sep 24, 2014 at 7:03
So you'd like to "return a uniquified array of software_for_products from the rows that have one of the given OSs"? — Taryn East
– Taryn East, Commented Sep 24, 2014 at 7:21
Actually I'd like for it to return a relation for each match for further processing. — user3797265
– user3797265, Commented Sep 24, 2014 at 7:24
sorry, I mucked my example up completely in the first edit. I fixed it now to better correspond what I'm looking for. — user3797265
– user3797265, Commented Sep 24, 2014 at 7:43

Sarathkumar · Accepted Answer · 2014-09-24 09:15:21Z

1

Please look into this gem.

And then do a query like

selected_products = ['Apple', 'Linux']
Software.where.overlap(osses: selected_products)

answered Sep 24, 2014 at 9:15

Sarathkumar

714 bronze badges

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

Collectives™ on Stack Overflow

Query column of arrays with array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related