Xlst to display a List Value from a Custom Property field

Tuesday, January 25, 2022
Avatar

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

  • This displays the List Value #

               td><xsl:value-of select="CUST_30"/></td> 

  • This does not display the List value instead displays blank.  What is the xslt syntax to display a list value not the  list value number.

<td><xsl:value-of select='CustomProperties/CustomProperty[Name="Custom_30"]/Value'/></td>

 

1 Replies
Wednesday, January 26, 2022
Avatar
re: derowe Tuesday, January 25, 2022

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

 

Statistics
  • Started: Tuesday, January 25, 2022
  • Last Reply: Wednesday, January 26, 2022
  • Replies: 1
  • Views: 787