Project

General

Profile

Feature #28786

RFE - Subscription report template

Added by Waldirio Pinheiro 4 months ago. Updated 2 months ago.

Status:
Closed
Priority:
Normal
Category:
Templates
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

Description of problem:
Currently, we can see the output as below
---
ID,Name,Available,Quantity,SKU,Contract number
6,Employee SKU,10,10,ES0113909,10169621
8,Employee SKU,-1,-1,ES0113909,10169621
9,ant-product,-1,-1,794374057445,""
10,Employee SKU,5,5,ES0113909,11986131
---

However, will be really interesting add some fields as below:
- Start Date
- End Date
- Account #
- Contract #
- Type
- Organization

Version-Release number of selected component (if applicable):
6.6.z

How reproducible:
100%

Steps to Reproduce:
1. WebUI - Monitor - Report Templates - Subscriptions - Generate
2.
3.

Actual results:
---
ID,Name,Available,Quantity,SKU,Contract number
6,Employee SKU,10,10,ES0113909,10169621
8,Employee SKU,-1,-1,ES0113909,10169621
9,ant-product,-1,-1,794374057445,""
10,Employee SKU,5,5,ES0113909,11986131
---

Expected results:
---
ID,Name,Available,Quantity,SKU,Contract number,Account number,Start date,End date,Organization
6,Employee SKU,10,10,ES0113909,10169621,540155,2013-04-23 21:00:00 0700,2021-12-31 20:59:59 -0800,org_label_here
8,Employee SKU,-1,-1,ES0113909,10169621,540155,2013-04-23 21:00:00 -0700,2021-12-31 20:59:59 -0800,org_label_here
9,ant-product,-1,-1,794374057445,"","",2019-12-23 13:08:59 -0800,2049-12-15 13:08:59 -0800,org_label_here
10,Employee SKU,5,5,ES0113909,11986131,540155,2019-08-12 21:00:00 -0700,2021-12-31 20:59:59 -0800,org_label_here
--

Additional info:


Related issues

Related to Katello - Feature #28789: Allow pool organization in safe modeClosed

Associated revisions

Revision 1549e9ab (diff)
Added by Waldirio Pinheiro 2 months ago

Fixes #28786 - add columns to subscription report

bumped minimal Katello version and inlcude organization to avoid N+1 SQL queries

Co-authored-by: Marek Hulán <>

History

#1 Updated by Waldirio Pinheiro 4 months ago

  • Pull request https://github.com/theforeman/community-templates/pull/681 added

#2 Updated by Ondřej Pražák 4 months ago

  • Category set to Templates
  • Project changed from Templates to Foreman

#3 Updated by Ondřej Pražák 4 months ago

  • Assignee set to Waldirio Pinheiro

#4 Updated by Marek Hulán 4 months ago

  • Related to Feature #28789: Allow pool organization in safe mode added

#5 Updated by Waldirio Pinheiro 2 months ago

  • Status changed from New to Closed

Also available in: Atom PDF