Bug 1788958

Summary: [RFE] add "elapsed time" column to export and hammer, make it filterable in WebUI
Product: Red Hat Satellite Reporter: Vladimír Sedmík <vsedmik>
Component: Tasks PluginAssignee: Adam Ruzicka <aruzicka>
Status: CLOSED ERRATA QA Contact: Peter Ondrejka <pondrejk>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.7.0CC: aruzicka, ehelms, magaphon
Target Milestone: 6.8.0Keywords: FutureFeature
Target Release: Unused   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: tfm-rubygem-foreman-tasks-1.1.0 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2020-10-27 12:59:52 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:

Description Vladimír Sedmík 2020-01-08 13:14:22 UTC 
Description of problem:
This BZ tracks remains from original https://bugzilla.redhat.com/show_bug.cgi?id=1474311.

1) The Export button and 'hammer task list' still provide output without 'Duration' column ('started_at' and 'ended_at' is provided), although the column exists in WebUI.

2) The Search Filter does not support 'duration' criteria (if I want to filter tasks with 'duration > 5 minutes' for example), although the column exists in WebUI.


Version-Release number of selected component (if applicable):
satellite 6.7 snap 7
tfm-rubygem-foreman-tasks-0.17.5


How reproducible:
Always


Steps to Reproduce:
1. in WebUI go to Monitor > Tasks
2. click Export button, save the csv file and explore it
3. enter to the search filter 'duration > 5 minutes'
4. ssh to the satellite and run 'hammer task list' 


Actual results:
the 'duration' column is missing and can't be used for filtering


Expected results:
the 'duration' column should be there and usable for filtering


Additional info:
Comment 3 Maria 2020-06-07 15:48:40 UTC 
Connecting redmine issue https://projects.theforeman.org/issues/28487 from this bug
Comment 4 Maria 2020-06-07 15:51:49 UTC 
The second part of this BZ was fixed in: https://projects.theforeman.org/issues/28487
The first part will be fixed in https://bugzilla.redhat.com/show_bug.cgi?id=1844848
Comment 6 Peter Ondrejka 2020-06-25 09:33:52 UTC 
Verified the duration search UI on Satellite 6.8 snap 6, see the discussion in https://github.com/theforeman/foreman-tasks/pull/486 for details
Comment 9 errata-xmlrpc 2020-10-27 12:59:52 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (Important: Satellite 6.8 release), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2020:4366