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.