Bug #18738
closed
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 almost 8 years ago.
Updated over 6 years ago.
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 to Feature #8448: As a UI user, I should see content available in an individual environment. added
- Status changed from New to Ready For Testing
- Pull request https://github.com/Katello/katello/pull/6639 added
- 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
- Translation missing: en.field_release set to 211
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?).
- Assignee changed from Eric Helms to Marek Hulán
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by 
Updated by