Project

General

Profile

Bug #18738

PG::Error: ERROR: missing FROM-clause entry for table "katello_environments" when viewing activation keys as a user with customized viewing permissions

Added by Marek Hulán about 2 years ago. Updated 11 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Activation Key
Target version:
Difficulty:
Triaged:
Yes
Bugzilla link:
Team Backlog:
Fixed in Releases:
Found in Releases:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1427282

Description of problem:

Activation keys page does not work if any filter with related permission contains some additional condition, e.g. environment = Library

How reproducible:

100%

Steps to Reproduce:

1. Create a user with filter with view_activation_keys permission, specifying condition environment = Library
2. Sign in to the webUI as that user
3. Try to view the activation keys page in the webUI

Actual results:

Traceback, half of which appears to complain about missing graphics and fonts.

Expected results:

The viewer filters should function without traceback.


Related issues

Related to Katello - Feature #8448: As a UI user, I should see content available in an individual environment.Closed2014-11-19

Associated revisions

Revision 211df8bc (diff)
Added by Marek Hulán about 2 years ago

Fixes #18738 - fixes the sub query

History

#1 Updated by Marek Hulán about 2 years ago

  • Related to Feature #8448: As a UI user, I should see content available in an individual environment. added

#2 Updated by The Foreman Bot about 2 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/6639 added

#3 Updated by Eric Helms about 2 years ago

  • Subject changed from PG::Error: ERROR: missing FROM-clause entry for table "katello_environments" when viewing activation keys as a user with customized viewing permissions to PG::Error: ERROR: missing FROM-clause entry for table "katello_environments" when viewing activation keys as a user with customized viewing permissions
  • Legacy Backlogs Release (now unused) set to 211

#4 Updated by Marek Hulán about 2 years ago

Btw I don't think this is specific for activation keys page. I'd say all katello resources that allows having filters on relations are affected. So far I found only activation key to be such resource, it allows filtering on lifecycle environments. Other resources allows to filter on organization_id which is own attribute (normally all resources in Foreman filters on organization, should this be unified?).

#5 Updated by Brad Buckingham about 2 years ago

  • Assignee changed from Eric Helms to Marek Hulán

#6 Updated by Marek Hulán about 2 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

Also available in: Atom PDF