Need help creating a custom report

Friday, February 8, 2019

Hi. I have been trying to create a custom report for the last several days and am having some issues finishing it. I want a report that allows me to see all instances of a certain type of incident(we call these incidents Epics), along with all of its associated incidents of two certain types(we call them features and deliverables). We don't necessarily need any data along with the Epics themselves other than the name and number of the incident, along with the associations of course. We would like a table for the associations to have the columns for incident type, incident ID, incident name, status, estimated effort, remaining effort, actual effort, and owner. I have created a mockup of what I want the report to look like:


 Report Mockup


The ability to filter certain fields before the report generates would be great if possible(especially helpful for detected release), similar to the way standard reports are now. If you could help provide some insight or code to help create this report, it would be much appreciated.







2 Replies
Friday, February 8, 2019
re: l.schumaker Friday, February 8, 2019 This is a link to the mockup picture. Not quite sure if it can be seen in my original post.

Tuesday, February 12, 2019
re: l.schumaker Friday, February 8, 2019
  1. For the ESQL it is generally best to start with one of the built in queries. These will give you a good guide on what data is available. There are dedicated tables in the database for ESQL purposes and they should be used in these built in queries.
  2. We do also have some example custom reports on our KB pages: these may give you some further insights, though none of the ones there are exactly what you are after.
  3. From my understanding of what you are trying to achieve, the built in incident detailed report will give you more information than you need, but is along the right lines. Now this does not export into excel, but it may be that filtering that report, and making sure to list linked incidents in it will give you what you need. If nothing else it could be a good starting point for your own report.

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885


  • Started: Friday, February 8, 2019
  • Last Reply: Tuesday, February 12, 2019
  • Replies: 2
  • Views: 7054