Fixes #16704 - Allow filtering on dashboard

Some filters on the dashboard caused the reports widget to break,
specifically searching using free text or on attributes that are not
part of the hosts table (such as environment name).
This is caused by an issue with Rails that digregards outer joins when a
query is used as an inner query for a where clause using hash syntax.

(cherry picked from commit ee008293f8396da52b4c2fa7870bf4114df1b25b)