SpiraTeam Reporting Queries

Friday, November 29, 2013 10:59:51 AM

Hi,

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
WHERE R.PROJECT_ID = ${ProjectId}

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 1:18:53 PM
Avatar
re: Loenhoet on Friday, November 29, 2013 10:59:51 AM
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.
Regards
Jim
Monday, December 2, 2013 9:31:14 AM
Avatar
re: inflectra.jimx on Friday, November 29, 2013

Hi Jim,

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

Tuesday, December 3, 2013 1:16:05 PM
Avatar
re: Loenhoet on Monday, December 2, 2013
This is good news - we have been anxiously waiting for this feature as well!
Monday, February 10, 2014 6:55:55 PM
Avatar
re: vsmith on 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.
Statistics
  • Started: Friday, November 29, 2013 10:59:51 AM
  • Last Reply: Monday, February 10, 2014 6:55:55 PM
  • Replies: 4
  • Views: 1001