Bug #17272

Searches on `parameters` with "!=" does not work as expected

Added by Swapnil Abnave 5 months ago. Updated 28 days ago.

Status:Closed
Priority:Normal
Assigned To:Dominik Hlavac Duran
Category:Search
Target version:Team Marek backlog
Difficulty: Bugzilla link:1392422
Found in release:nightly Pull request:https://github.com/theforeman/foreman/pull/4324, https://github.com/theforeman/foreman/pull/4323
Story points-
Velocity based estimate-
Release1.15.0Release relationshipAuto

Description

Description of problem:
Host parameters search does not return expected results when using the "!=" operator.

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

How reproducible:
always

Steps to Reproduce:
1. Create a global parameter 'myparam' with value "1".
2. Override the parameter on one host with value "2".
3. Search for hosts matching "params.myparam != 0"

Actual results:
Only the overriden host is displayed.

Expected results:
All hosts are displayed.


Related issues

Related to Foreman - Bug #16565: Searches with global parameters and overrides returning i... Closed 09/15/2016

Associated revisions

Revision 38ac46e5
Added by Dominik Hlavac 28 days ago

Fixes #17272 - Fixed Searches on parameters with !=

Revision 4ada010b
Added by Ivan Necas 28 days ago

Refs #17272 - fix sql condition

1==1 is not a valid SQL condition.

History

#1 Updated by Swapnil Abnave 4 months ago

  • Target version changed from Team Anurag backlog to Team Anurag Iteration 6

#2 Updated by Swapnil Abnave 4 months ago

  • Target version changed from Team Anurag Iteration 6 to Team Anurag backlog

#3 Updated by Dominik Hlavac Duran 3 months ago

  • Assigned To set to Dominik Hlavac Duran
  • Target version changed from Team Anurag backlog to Team Marek backlog

#4 Updated by Tomer Brisker 2 months ago

  • Related to Bug #16565: Searches with global parameters and overrides returning incorrect results added

#5 Updated by The Foreman Bot 28 days ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/4323 added

#6 Updated by Anonymous 28 days ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

#7 Updated by The Foreman Bot 28 days ago

  • Pull request https://github.com/theforeman/foreman/pull/4324 added

#8 Updated by Marek Hulán 28 days ago

  • Release set to 1.15.0

Also available in: Atom PDF