Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > Xlst to display a List V...
Have created an Incident Custom Property which is a list.
example
List Value # VAlue
PV:21916 Functional
PV:21919 Regression
In Reports created a custom query and want to display the List Value. Only the List Value # is being displayed.
select R.CUST_30, COUNT (R.INCIDENT_ID) as COUNT
from SpiraTestEntities.R_Incidents as R
where R.PROJECT_ID = ${ProjectId} and R.DETECTED_RELEASE_ID in {${ReleaseAndChildIds}}
group by R.CUST_30
Default Template Calls
td><xsl:value-of select="CUST_30"/></td>
<td><xsl:value-of select='CustomProperties/CustomProperty[Name="Custom_30"]/Value'/></td>
Hi
Here are two related articles that I think will help:
More generally:
left join SpiraTestEntities.R_CustomListValues as C on cast (R.CUST_02 as decimal) = C.CUSTOM_PROPERTY_VALUE_ID
And if you have any questions, please email or call us at +1 (202) 558-6885