SpiraTeam Reporting Queries

Friday, November 29, 2013


I was currently investigating custom properties and custom lists for requirements. I was able to customize the requirement details to our preference using these custom properties and custom lists.

However, when using the Reporting Engine (Administative Panel), I am able to read all custom properties for the requirements (using the default query, I am able to see the table field names). I use this (simplified) query:

SELECT R.CUST_01 As Reference, R.NAME As Requirement
FROM SpiraTestEntities.R_Requirements as R

However, since the field CUST_03 is linked to a list, I am able to see the index that is used when defining the custom list (of which the indices change after a new project is created from the same template). Is there a way to get these list values in this query as well?

I also tried to incorporate the mapping from index to value in the XSLT, but this is no solution since the indexes will change for each new project.

4 Replies
Friday, November 29, 2013
re: Loenhoet Friday, November 29, 2013
Hi Stefan
In the current version (v4.0) there is no reportable entity for the custom list values, so it's not possible to join those list values to get the names. We shall be adding the custom properties, custom lists and custom values as reportable entities in v4.1, so once that is released, it will be possible.
Monday, December 2, 2013
re: inflectra.jimx Friday, November 29, 2013

Hi Jim,

thank you for the update, we will await version 4.1 soon.

Tuesday, December 3, 2013
re: Loenhoet Monday, December 2, 2013
This is good news - we have been anxiously waiting for this feature as well!
Monday, February 10, 2014
re: vsmith Tuesday, December 3, 2013
Has this feature now been added to v4.1?  Can you provide some details?  I don;t see it mentioned in the updated Administration manual.

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, November 29, 2013
  • Last Reply: Monday, February 10, 2014
  • Replies: 4
  • Views: 2617