Description of problem: There is no option to search any records based on nil or empty record.
For eg. I would like to list all hosts which are not linked with any hostgroup. Currently, this is not possible.
We should support search option(on "ALL hosts" page) like
hostgroup = nil or hostgroup = ""
1. Proposed title of this feature request
I would like to request the ability to search for a host with no hostgroup set.
3. What is the nature and description of the request?
I use the host groups to perform Ansible Tower jobs against and need to view any Satellite hosts with a null hostgorup.
4. Why does the customer need this? (List the business requirements here)
I need this to ensure Ansible Tower is running on all hosts.
5. Is there already an existing RFE upstream or in Red Hat Bugzilla?
6. Does the customer have any specific timeline dependencies and which release would they like to target (i.e. RHEL5, RHEL6)?
I would like to see this feature added as soon as possible to ensure host deployment and standardization is occurring.
7. Is the sales team involved in this request and do they have any additional input?
8. List any affected packages or components.
9. Would the customer be able to assist in testing this functionality if implemented?
Yes I would be able to help test.
Created redmine issue http://projects.theforeman.org/issues/22821 from this bug
This is in fact already possible by using null? operator, for the query from comment 0, you can use following
I'm moving this to a documentation component to document this operator in Administering guide, more specifically it should land at https://access.redhat.com/documentation/en-us/red_hat_satellite/6.3/html/administering_red_hat_satellite/chap-red_hat_satellite-administering_red_hat_satellite-searching_and_bookmarking#sect-Red_Hat_Satellite-Administering_Red_Hat_Satellite-Operators
For docs team:
please document "null? whatever" finds records for which whatever is NULL in database, there's also the opposite operator "set?" so e.g. "set? hostgroup" in hosts search will only find hosts that has some host group assigned
since it's an unary operator, it can be joined with and/or, e.g. "null? environment and set? hostgroup" will find hosts that does not have any environment set but they are assigned some hostgroup
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/22821 has been resolved.
(In reply to email@example.com from comment #5)
> Moving this bug to POST for triage into Satellite 6 since the upstream issue
> http://projects.theforeman.org/issues/22821 has been resolved.
This is now a docs bug, moving back to Assigned, clearing keywords, clearing Flags
These changes are now live on the customer portal
4.1.1. Query Syntax