If you need to extract comments for artifact, for a period of time or filtered by comment creator - you can easily do that using Custom Report tool or - if you're using SpiraPlan you can use OData or (PowerBI Desktop) to visually create reports and analysis.
The new release of SpiraTest, SpiraPlan and SpiraTeam 4.0 includes the ability to write custom reports against various reportable entities. This articles provides a list of the available entities.
This article is now obsolete.Currently Spira has a number of views available that helps to create powerful custom reports using ESQL queries. Each available table is listed with all of their exact field names. In our documentation you can find a full list of available custom report tables.
Spira 4.1 onwards includes the ability to write custom reports against various reportable entities.This article provides a list of reportable entities that were available in Spira version 4.1 through to 5.4
One common requirement is to run a query in an application being tested and verify that the data on the screen matches the data in the application. This article explains the recommended process for doing this.
If you're using SpiraPlan's OData to extract data, Power Query helps with extraction and transformations steps that are represented as queries with share options to be used by other users.This article covers the general mechanisms to share a query in Power Query.
A customer recently asked about creating a custom graph based on a set of values in a custom list on an artifact. This article explains how this can be done.