Skip Navigation LinksForums > SpiraTeam Forums > SpiraTeam Issues & Questi... > SpiraTeam Reporting Queri...

SpiraTeam Reporting Queries RSS Feed

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
Jim R.Jim R.
re: Stefan van Loenhout on Friday, November 29, 2013
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.
Stefan van LoenhoutStefan van Loenhout
re: Jim R. on Friday, November 29, 2013
Monday, December 2, 2013

Hi Jim,

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

Vanessa SmithVanessa Smith
re: Stefan van Loenhout on Monday, December 2, 2013
Tuesday, December 3, 2013
This is good news - we have been anxiously waiting for this feature as well!
Vanessa SmithVanessa Smith
re: Vanessa Smith on Tuesday, December 3, 2013
Monday, February 10, 2014
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.
  • Started: 11/29/2013
  • Last Reply: 2/10/2014
  • Replies: 4
  • Views: 536
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.