Query if array column contains one or more values

ruby-on-rails arrays postgresql activerecord rails-activerecord

Something like this should work:

Report.where('department_ids @> ARRAY[?]::integer[]', [2, 5])

You could find more information about array functions and operators here

CodeHunter