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

Actions

Copy link

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 about 7 years ago. Updated almost 6 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Marek Hulán

Category:

Activation Key

Target version:

Katello 3.4.0

Difficulty:

Triaged:

Bugzilla link:

1427282

Pull request:

https://github.com/Katello/katello/pull/6639

Fixed in Releases:

Found in Releases:

Red Hat JIRA:

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 1 (0 open — 1 closed)

Actions

Copy link

Updated by Marek Hulán about 7 years ago

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

Actions

Copy link

Updated by The Foreman Bot about 7 years ago

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

Actions

Copy link

Updated by Eric Helms about 7 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
translation missing: en.field_release set to 211

Actions

Copy link

Updated by Marek Hulán about 7 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?).

Actions

Copy link