1888667 – "Applied Errata" report template does not consider input "Up to" and "Since" in WebUI, hammer works

Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.

Bug 1888667 - "Applied Errata" report template does not consider input "Up to" and "Since" in WebUI, hammer works

Summary: "Applied Errata" report template does not consider input "Up to" and "Since" ...

Keywords:
Status:	CLOSED ERRATA
Alias:	None
Product:	Red Hat Satellite
Classification:	Red Hat
Component:	Reporting
Sub Component:
Version:	6.7.0
Hardware:	All
OS:	All
Priority:	medium
Severity:	medium
Target Milestone:	6.13.0
Assignee:	satellite6-bugs
QA Contact:	Sam Bible
Docs Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+	depends on / blocked

Reported:	2020-10-15 13:12 UTC by Ranjan Kumar
Modified:	2024-03-25 16:43 UTC (History)
CC List:	6 users (show)
Fixed In Version:
Doc Type:	If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed:	2023-05-03 13:20:33 UTC
Target Upstream Version:
Embargoed:

Attachments	(Terms of Use)

Links
System	ID	Private	Priority	Status	Summary	Last Updated
Foreman Issue Tracker	31744	0	Normal	New	"Applied Errata" report template does not consider input "Up to" and "Since" in WebUI, hammer works	2022-08-19 17:20:16 UTC
Red Hat Product Errata	RHSA-2023:2097	0	None	None	None	2023-05-03 13:21:00 UTC

Description Ranjan Kumar 2020-10-15 13:12:01 UTC

Description of problem: Applied errata report doesn't consider input Since and 'Up to'. It returns all the result.

Selected Since 15th Oct and upto 15th Oct But result contains 18th Oct 
date	                  hostname	                     erratum_id	  erratum_type	status
2020-09-18 08:59:33 +0530 rhel7u5-1.gsslab.rdu2.redhat.com   RHBA-2020:3615 bugfix	success


Satellite log also confirm, since and up_to is not in parameter list
here is production log
~~~
2020-10-15T18:22:06 [I|app|b56f2285] Started POST "/templates/report_templates/197-Applied%20Errata/schedule_report" for 10.74.9.242 at 2020-10-15 18:22:06 +0530
2020-10-15T18:22:06 [I|app|b56f2285] Processing by ReportTemplatesController#schedule_report as HTML
2020-10-15T18:22:06 [I|app|b56f2285]   Parameters: {"utf8"=>"✓", "authenticity_token"=>"vqzyuzBcNUhF++JBl7ZpoPHTMo3hq9f6z43VMfALv+Du7hKZTcV7F98biivLDzfNSfCCo9bwBH+kgpSsrBgxqw==", "report_template_report"=>"[FILTERED]", "commit"=>"Submit", "id"=>"197-Applied Errata"}
2020-10-15T18:22:07 [I|app|b56f2285] Enqueued TemplateRenderJob (Job ID: d96240ac-c6d4-4951-a30c-c1d7bd2eff2a) to Dynflow(default) with arguments: {"template_id"=>"197-Applied Errata", "gzip"=>false, "send_mail"=>false, "mail_to"=>"a", "format"=>"csv", "input_values"=>{"55"=>{"value"=>"all"}, "56"=>{"value"=>"no"}, "57"=>{"value"=>"success"}}}, {:user_id=>62}
2020-10-15T18:22:07 [I|app|b56f2285] Redirected to https://dhcp131-99.gsslab.pnq2.redhat.com/templates/report_templates/197-Applied%20Errata/report_data?job_id=d96240ac-c6d4-4951-a30c-c1d7bd2eff2a
2020-10-15T18:22:07 [I|app|b56f2285] Completed 302 Found in 182ms (ActiveRecord: 22.7ms)
~~~

Version-Release number of selected component (if applicable): Satellite 6.7

How reproducible: Always

Steps to Reproduce:
1. Go to Monitor -> Report Template --> "Host - Applied Errata" --> generate 
2. Fill up Since and Up to
3. It doesn't consider since and upto and list all applied errata

Actual results: Return wrong result


Expected results: Should consider since and upto input value.


Additional info: 
Hammer works fine, here is an exaple
# hammer report-template generate --name "Applied Errata" --inputs 'Filter Errata Type="all",Include Last Reboot="no",Status="success",Since="2020-09-18 00:29:30",Up to="2020-09-18 03:50:33"'
date,hostname,erratum_id,erratum_type,status
2020-09-18 03:29:33 UTC,rhel7u5-1.gsslab.rdu2.redhat.com,RHBA-2020:3615,bugfix,success

Comment 1 Dominik Matoulek 2021-01-28 10:08:20 UTC

Created redmine issue https://projects.theforeman.org/issues/31744 from this bug

Comment 6 Brad Buckingham 2022-11-03 21:47:41 UTC

Upon review of our valid but aging backlog the Satellite Team has concluded that this Bugzilla does not meet the criteria for a resolution in the near term, and are planning to close in a month. This message may be a repeat of a previous update and the bug is again being considered to be closed. If you have any concerns about this, please contact your Red Hat Account team.  Thank you.

Comment 7 Brad Buckingham 2022-11-07 14:33:10 UTC

This bugzilla was not reproducible on 6.11 and later.  We are aligning this to 6.13 for QE verification.

Comment 8 Sam Bible 2023-03-01 18:33:42 UTC

Verified on 6.13 - Snap 12

Steps to Verify:
1) Register a host.
2) Enable and Sync a repository that includes applicable erratum.
3) Apply at least 1 errata to a host.
4) Generate a "Applied Errata" report

Expected Results:
When using either Since or Up To options in the template, the report will respect these parameters.

Actual Results:
When using either Since or Up To options in the template, the report will respect these parameters.

Comment 11 errata-xmlrpc 2023-05-03 13:20:33 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.13 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-2023:2097

Note You need to log in before you can comment on or make changes to this bug.