PG::Error: ERROR: missing FROM-clause entry for table "katello_host_collections

Issue

Satellite 6.2.4 dashboard showing the below error when select "~" user role in filter logic.

PG::Error: ERROR: missing FROM-clause entry for table "katello_host_collections"
 LINE 1:
 ...id" IN (1) AND "hosts"."location_id" IN (2) AND (("katello_h... ^ :
 SELECT COUNT(count_column)
 FROM
 (SELECT 1 AS count_column FROM "katello_errata"
          INNER JOIN "katello_content_facet_errata" ON "katello_content_facet_errata"."erratum_id" = "katello_errata"."id" 
          INNER JOIN "katello_content_facets" ON "katello_content_facets"."id" = "katello_content_facet_errata"."content_facet_id"
               WHERE "katello_content_facets"."host_id" IN
                       (SELECT "hosts"."id" FROM "hosts" WHERE "hosts"."type"
                           IN ('Host::Managed') AND "hosts"."organization_id"
                           IN (1) AND "hosts"."location_id" IN (2) AND (("katello_host_collections"."name" ILIKE '%Test Hostcollection 1%'))) LIMIT 6)
                      subquery_for_count