Note: This is a public test instance of Red Hat Bugzilla. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback at bugzilla.redhat.com.
Bug 1150982 - [RFE] Extend set of filtering option-classes for non equality (!=), greater than or equal (>=), and less than or equal (<=)
Summary: [RFE] Extend set of filtering option-classes for non equality (!=), greater t...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 2.2
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Matej Kollar
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space23
TreeView+ depends on / blocked
 
Reported: 2014-10-09 11:11 UTC by Matej Kollar
Modified: 2015-04-14 19:03 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of: 1054359
Environment:
Last Closed: 2015-04-14 19:03:04 UTC
Embargoed:

Attachments (Terms of Use)

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
Note You need to log in before you can comment on or make changes to this bug.