Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1150982

Summary:	[RFE] Extend set of filtering option-classes for non equality (!=), greater than or equal (>=), and less than or equal (<=)
Product:	[Community] Spacewalk	Reporter:	Matej Kollar <mkollar>
Component:	Server	Assignee:	Matej Kollar <mkollar>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	2.2	CC:	cperry, jlyle, mkollar, satqe-list, xdmoon
Target Milestone:	---	Keywords:	FutureFeature
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Enhancement
Doc Text:		Story Points:	---
Clone Of:	1054359	Environment:
Last Closed:	2015-04-14 19:03:04 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1207293

Description Matej Kollar 2014-10-09 11:11:53 UTC

Add functionality to spacewalk-report, that will enable to filter
not only by equality and "like", but also on (!=), (<=), and (>=).

Motivation behind this is, that

* results can be filtered by date ranges
* reports like scap-scan-results cab be
* filtered by not having result equal to pass

Comment 1 Matej Kollar 2014-10-09 11:22:47 UTC

spacewalk.git: a88e1585295936ae2963fa425acca8be9772b2fa
  adds org_id column to scap-scan
spacewalk.git: a88e1585295936ae2963fa425acca8be9772b2fa
spacewalk.git: 8cc9d1580ebf4ecefcf2ff668a9f27d52a3f62ee
  add new options that will allow to filter not only by
  equality and "like", but also
  * non-equality (/=)...     `--ne-where-<column-id>`
  * less than or equal (<=)  `--le-where-<column-id>`
  * more than or equal (>=)  `--ge-where-<column-id>`.

example (on PostgreSQL... time format on Oracle might be different):

    # spacewalk-report scap-scan --ge-where-end_time='2014-10-02 22:00:00'
    org_id,system_id,hostname,ip_address,event_id,testresult_id,name,benchmark,benchmark_version,profile,profile_title,end_time
    1,1000010000,client1.example.com,10.0.0.2,11,7,xccdf_org.open-scap_testresult_RHEL6-Default,RHEL-6,0.2,RHEL6-Default,Default install settings,2014-10-02 22:12:56

Comment 2 Matej Kollar 2014-10-09 13:25:13 UTC

spacewalk.git: a120cffd85acae5a7af99696b97786878d1cd5e4
  fix missing where

Comment 3 Matej Kollar 2014-10-11 19:05:40 UTC

spacewalk.git: 9ad62113781f139a9503e340ecd4e04e9f5542f4
  coping with old python

Comment 4 Matej Kollar 2014-10-15 14:53:27 UTC

spacewalk.git: bf5eba0b5b2afc54b634ac2213c39dbe972fbf59
   coping with issues caused by DB backed diversity...

Comment 5 Matej Kollar 2014-10-16 11:00:01 UTC

spacewalk.git: 3e97c9c22d0a7ac21b1a918dc3381ec2c4023bad
  man page updated

Comment 6 Grant Gainey 2015-03-23 16:59:02 UTC

Moving bugs to ON_QA as we move to release Spacewalk 2.3

Comment 7 Grant Gainey 2015-04-14 19:03:04 UTC

Spacewalk 2.3 has been released. See

https://fedorahosted.org/spacewalk/wiki/ReleaseNotes23