SpiraTeam Reporting Queries

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.