Description of problem: Applying a filter (aka a search) on organization returns a postgres error. Version-Release number of selected component (if applicable): katello-headpin-0.1.103-1.git.0.2f8b500.el6.noarch katello-headpin-all-0.1.103-1.git.0.2f8b500.el6.noarch katello-cli-headpin-0.1.12-1.git.0.cd192f2.el6.noarch Steps to Reproduce: 1. Navigate to Organization 2. In the search box enter criteria 3. Apply filter Actual results: PGError: ERROR: column reference "name" is ambiguous LINE 1: ...ON ("organizations".id) "organizations".id, lower(name) AS a... ^ : SELECT * FROM (SELECT DISTINCT ON ("organizations".id) "organizations".id, lower(name) AS alias_0 FROM "organizations" LEFT OUTER JOIN "environments" ON "environments"."organization_id" = "organizations"."id" AND "environments"."locker" = 'f' LEFT OUTER JOIN "providers" ON "providers"."organization_id" = "organizations"."id" WHERE (("organizations"."name" ILIKE '%test%' OR "organizations"."description" ILIKE '%test%' OR "environments"."name" ILIKE '%test%' OR "environments"."description" ILIKE '%test%' OR "providers"."name" ILIKE '%test%' OR "providers"."description" ILIKE '%test%' OR "providers"."repository_url" ILIKE '%test%'))) AS id_list ORDER BY id_list.alias_0 LIMIT 25 OFFSET 0 Expected results: Filter applied and left pane list displays only items matching criteria. Additional info: This appears to be a regression.
Possibly a dupe of bug #750120
Can this get re-tested since 750120 is MODIFIED? *** This bug has been marked as a duplicate of bug 750120 ***