Project

General

Profile

Bug #17272

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

Added by Swapnil Abnave over 4 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Normal
Category:
Search
Target version:
Difficulty:
Triaged:
Bugzilla link:

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 incorrect resultsClosed2016-09-15

Associated revisions

Revision 38ac46e5 (diff)
Added by Dominik Hlavac Duran over 4 years ago

Fixes #17272 - Fixed Searches on parameters with !=

Revision 4ada010b (diff)
Added by Ivan Necas over 4 years ago

Refs #17272 - fix sql condition

1==1 is not a valid SQL condition.

History

#1 Updated by Swapnil Abnave over 4 years ago

  • Target version changed from 1.15.6 to 1.15.1

#2 Updated by Swapnil Abnave over 4 years ago

  • Target version changed from 1.15.1 to 1.15.6

#3 Updated by Dominik Hlavac Duran over 4 years ago

  • Assignee set to Dominik Hlavac Duran
  • Target version changed from 1.15.6 to 115

#4 Updated by Tomer Brisker over 4 years ago

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

#5 Updated by The Foreman Bot over 4 years ago

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

#6 Updated by Anonymous over 4 years ago

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

#7 Updated by The Foreman Bot over 4 years ago

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

#8 Updated by Marek Hulán over 4 years ago

  • Legacy Backlogs Release (now unused) set to 209

Also available in: Atom PDF