Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.
Bug 1472863 - Searching for specific organizations/locations broken
Summary: Searching for specific organizations/locations broken
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Search
Version: 6.3.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: Unspecified
Assignee: Ondřej Pražák
QA Contact: Jitendra Yejare
URL: http://projects.theforeman.org/issues...
Whiteboard:
: 1479885 (view as bug list)
Depends On:
Blocks: 1373844
TreeView+ depends on / blocked
 
Reported: 2017-07-19 14:41 UTC by Jitendra Yejare
Modified: 2019-08-12 14:04 UTC (History)
5 users (show)

Fixed In Version: scoped_search-4.1.2
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-02-21 16:54:17 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 19707 0 None None None 2017-07-19 15:05:54 UTC

Description Jitendra Yejare 2017-07-19 14:41:41 UTC
If I try to search through subnets with location_id every subnet is returned as long as the location_id actually exists. If I search for a nonexsitent location_id no subnet gets returned.
Also searching for organizations seems to be broken too, because when I enter a location name as organization I get a list of all subnets.


Examples:

Subnet1:
  name: net1-mgmt
  location_id: 8

Subnet2:
  name: net2-mgmt
  location_id: 9


search_string: location_id = 9 and name ~ net%-mgmt

Result: Both Subnets
Expected Result: Subnet2


search_string: location_id = 90 and name ~ net%-mgmt

Result: Nothing
Expected Result: Nothing (this is actually correct)


search_string: organization_id = 9 and name ~ net%-mgmt

Result: Both Subnets
Expected Result: Nothing as organization_id 9 does not exist

Comment 1 Jitendra Yejare 2017-07-19 14:41:45 UTC
Created from redmine issue http://projects.theforeman.org/issues/19707

Comment 4 Satellite Program 2017-08-25 16:14:25 UTC
Upstream bug assigned to oprazak

Comment 5 Ondřej Pražák 2017-08-31 11:08:45 UTC
*** Bug 1479885 has been marked as a duplicate of this bug. ***

Comment 6 Jitendra Yejare 2017-10-25 10:04:44 UTC
Verified!

@ Satellite 6.3 snap 21

Steps:
Same as mentioned in Description

Behavior: 
The number of filters in 'Organization Admin' roles in upgraded 6.3 and freshly installed satellite are same.

Comment 7 Jitendra Yejare 2017-10-25 10:14:16 UTC
Sorry I accedently updated this bug instead of https://bugzilla.redhat.com/show_bug.cgi?id=1501414

Moving back to ON_QA.

Comment 8 Jitendra Yejare 2017-10-25 13:15:29 UTC
Verified!

@Satellite 6.3 snap 21

Steps:

Scenario 1:
------------------------

Subnet1:
  name: net1-mgmt
  location_id: 8

Subnet2:
  name: net2-mgmt
  location_id: 9


search_string: location_id = 9

Result: subnet2
Expected Result: Subnet2


search_string: location_id = 90

Result: Nothing
Expected Result: Nothing


search_string: organization_id = 9

Result: Nothing
Expected Result: Nothing


Scenario2:
------------------

1. Created Org Admin role and assigned any taxonomies to it
2. Created user and assigned above Org Admin role to it
3. Login with above Org Admin user
4. Go to Context Switcher, check if 'Manage Organizations' links are available

Result:
Manage Organizations option is not available and manage locations option is available as expected.

Hence changing the state to Veriifed as the results are expected.

Comment 9 Satellite Program 2018-02-21 16:54:17 UTC
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA.
> 
> For information on the advisory, and where to find the updated files, follow the link below.
> 
> If the solution does not work for you, open a new bug report.
> 
> https://access.redhat.com/errata/RHSA-2018:0336


Note You need to log in before you can comment on or make changes to this bug.