Hide Forgot
Description of problem: Trying to run a filter on orgs throws nasty error. Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. Navigate to Administration Organizations 2. Enter "AC" in the filter box and submit 3. 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 '%AC%' OR "organizations"."description" ILIKE '%AC%' OR "environments"."name" ILIKE '%AC%' OR "environments"."description" ILIKE '%AC%' OR "providers"."name" ILIKE '%AC%' OR "providers"."description" ILIKE '%AC%' OR "providers"."repository_url" ILIKE '%AC%'))) AS id_list ORDER BY id_list.alias_0 LIMIT 25 OFFSET 0 Expected results: Some sort of proper result. Additional info:
cswiii will get us the search gem version since this may be fixed in the latest
*** Bug 753095 has been marked as a duplicate of this bug. ***
fixed in scoped_search version 2.3.6.
moving back to assigned... this particular issue is actually an error in the application code vs the scope_search gem
git commit: da81ac130c6cdc4fe32abbd870415e5bf71161a0
Verified in katello-headpin-all-0.1.104-1.git.0.2ec5e64.el6.noarch
*** Bug 753170 has been marked as a duplicate of this bug. ***
Verified.
getting rid of 6.0.0 version since that doesn't exist