Description of problem:

The search logic in the "Administer --> Settings" page is completely broken in the UI of Satellite 7.0. Even the conditional searches are giving unexpected and incorrect outputs.

Version-Release number of selected component (if applicable):

satellite-7.0.0-0.5.beta.el8sat.noarch
foreman-3.1.1.6-1.el8sat.noarch

How reproducible:

Always

Steps to Reproduce:

1. Install Satellite 7.0 on RHEL 8, with first organization name set as RedHat and location name set as GSS

2. Run following commands in Satellite CLI or else make use of the same search queries in Satellite UI --> Administer --> Settings page.

1. hammer settings list --search "remote_execution"
2. hammer settings list --search "remote_execution_by_default or remote_execution_ssh_user"
3. hammer settings list --search "name ~ remote_execution"
4. hammer settings list --search "name = remote_execution_by_default or name = remote_execution_ssh_user"
5. hammer settings list --search "name ~ remote_execution_by_default or name ~ remote_execution_ssh_user"
6. hammer settings list --search "name = remote_execution_by_default and name = remote_execution_ssh_user"
7. hammer settings list --search "name = remote_execution_by_default or name ~ remote_execution_ssh_user"
8. hammer settings list --search "name ~ remote_execution_by_default or name = remote_execution_ssh_user"

Actual results:

• • Right output

1. hammer settings list --search "remote_execution"
   ------------------------------------------------|----------------------------------------------------|---------------------------------|--------------------------------------------------------------------------------
   NAME | FULL NAME | VALUE | DESCRIPTION
   ------------------------------------------------|----------------------------------------------------|---------------------------------|--------------------------------------------------------------------------------
   remote_execution_by_default | Use remote execution by default | false | If this is enabled, remote execution is used instead of katello-agent for rem...
   remote_execution_prefer_registered_through_proxy | Prefer registered through proxy for remote execution | false | Prefer using a proxy to which a host is registered when using remote execution
   remote_execution_fallback_proxy | Fallback to Any Proxy | false | Search the host for any proxy with Remote Execution, useful when the host has...
   remote_execution_global_proxy | Enable Global Proxy | true | Search for remote execution proxy outside of the proxies assigned to the host...
   remote_execution_ssh_user | SSH User | root | Default user to use for SSH. You may override per host by setting a paramete...
   ..
   ..
   ..

• • Free form search broken

1. hammer settings list --search "remote_execution_by_default or remote_execution_ssh_user"
   ----|---------|-----|-----------
   NAME | FULL NAME | VALUE | DESCRIPTION
   ----|---------|-----|-----------

• • The 'LIKE' conditional is not working

1. hammer settings list --search "name ~ remote_execution"
   ----|---------|-----|-----------
   NAME | FULL NAME | VALUE | DESCRIPTION
   ----|---------|-----|-----------

1. hammer settings list --search "name = remote_execution_by_default or name = remote_execution_ssh_user"
   ---------------------------|-------------------------------|-----|--------------------------------------------------------------------------------
   NAME | FULL NAME | VALUE | DESCRIPTION
   ---------------------------|-------------------------------|-----|--------------------------------------------------------------------------------
   remote_execution_by_default | Use remote execution by default | false | If this is enabled, remote execution is used instead of katello-agent for rem...
   ---------------------------|-------------------------------|-----|--------------------------------------------------------------------------------

• • Or logic broken or I should say, Only the first declaration is always honored

1. hammer settings list --search "name ~ remote_execution_by_default or name ~ remote_execution_ssh_user"
   ----|---------|-----|-----------
   NAME | FULL NAME | VALUE | DESCRIPTION
   ----|---------|-----|-----------

1. hammer settings list --search "name = remote_execution_by_default or name ~ remote_execution_ssh_user"
   ---------------------------|-------------------------------|-----|--------------------------------------------------------------------------------
   NAME | FULL NAME | VALUE | DESCRIPTION
   ---------------------------|-------------------------------|-----|--------------------------------------------------------------------------------
   remote_execution_by_default | Use remote execution by default | false | If this is enabled, remote execution is used instead of katello-agent for rem...
   ---------------------------|-------------------------------|-----|--------------------------------------------------------------------------------

1. hammer settings list --search "name ~ remote_execution_by_default or name = remote_execution_ssh_user"
   ---------------------------|-------------------------------|-----|--------------------------------------------------------------------------------
   NAME | FULL NAME | VALUE | DESCRIPTION
   ---------------------------|-------------------------------|-----|--------------------------------------------------------------------------------
   remote_execution_by_default | Use remote execution by default | false | If this is enabled, remote execution is used instead of katello-agent for rem...
   ---------------------------|-------------------------------|-----|--------------------------------------------------------------------------------

• • And logic should have given blank output but again it seems, anything from\after "and" is being ignored

1. hammer settings list --search "name = remote_execution_by_default and name = remote_execution_ssh_user"
   ---------------------------|-------------------------------|-----|--------------------------------------------------------------------------------
   NAME | FULL NAME | VALUE | DESCRIPTION
   ---------------------------|-------------------------------|-----|--------------------------------------------------------------------------------
   remote_execution_by_default | Use remote execution by default | false | If this is enabled, remote execution is used instead of katello-agent for rem...
   ---------------------------|-------------------------------|-----|--------------------------------------------------------------------------------

The exact same results will be observed from Satellite UI as well.

Expected results:

They should give expected outputs and honor the logical operators as well.

Additional info:

This works fine on Satellite 6.10.