Multiselect list values displaying in custom

Friday, January 16, 2026
Avatar

Hello,

I have been trying to modify a custom report which throws an error due to a multiselect list custom propery from test runs and have encountered a similar issue as described in the forum below:

https://www.inflectra.com/Support/Forum/spirateam/reports/2265.aspx

I've reviewed the KB that was linked in the responses to the forum (https://www.inflectra.com/Support/KnowledgeBase/KB638.aspx) and have attempted to include the join and the Contains, EndsWith and StartsWith set of functions to the report query. The report is no longer throwing the error when generated, however it is only displaying the first value when multiple values are selected. The KB seems to describe creating a graph and I'm wondering if since I'm updating a report instead does the XSLT template require a modification as well to allow these values to display separated by commas?

Here is the original query that was causing errors due to the custom property being a multiselect list:

--pulling in the Environment information from the LOV
left join
(select    
        SubC.CUSTOM_PROPERTY_VALUE_ID,
        SubC.NAME
from SpiraTestEntities.R_CustomListValues as SubC
where SubC.PROJECT_ID = ${ProjectId}
and SubC.IS_DELETED = False) as CB on 
CAST(R.CUST_02 as INT32) = CB.CUSTOM_PROPERTY_VALUE_ID

Here is what it was updated to:

--pulling in the Environment information from the LOV
left join
(select    
        SubC.CUSTOM_PROPERTY_VALUE_ID,
        SubC.NAME
from SpiraTestEntities.R_CustomListValues as SubC
where SubC.PROJECT_ID = ${ProjectId}
and SubC.IS_DELETED = False) as CB 
on Contains(R.CUST_02, Concat(Concat('0', CAST(CB.CUSTOM_PROPERTY_VALUE_ID as Edm.String)), ','))
or EndsWith(R.CUST_02, Concat('0', CAST(CB.CUSTOM_PROPERTY_VALUE_ID as Edm.String)))
or StartsWith(R.CUST_02, CAST(CB.CUSTOM_PROPERTY_VALUE_ID as Edm.String))

Also the XML code for the XSLT template for the value:

         <th>Environment</th>
         <td><xsl:value-of select="Custom02"/></td>         
        </tr>

Thank you.

3 Replies
Friday, January 16, 2026
Avatar
re: robbim01 Friday, January 16, 2026

Hello,

Please check article KB726 - How to get the names of Custom List values instead of their IDs as it describes how to use JOIN with multiselect lists.

I do not think XSLT requires a specific modification, it is more important for you to see the output in the preview first.

Let us know if that helped.

 

Regards,
Victoria -

 

Monday, January 19, 2026
Avatar
re: inflectra.Victoria Friday, January 16, 2026

Hello,

I'm able to successfully display only the first value that was selected from the test run multiselect custom property which uses a global custom list however additional values that are selected for the single multiselect list are not displaying in the report after using the Contains, EndsWith and StartsWith set of functions to the report query.

Using the example from the KB linked in your response, if the project titled 'Billing System' were to have two or more options selected for a single custom property such as having both 'Cat' and 'Dog' selected for the 'Pets' custom property, would the query require additional modification to allow all of the options selected for the single custom property to display in the report?

Thank you.

Tuesday, January 20, 2026
Avatar
re: robbim01 Sunday, January 18, 2026

Hello,

As described in KB726, to display all the values (not only first), you need to use UNION function to get the rest if the properties displayed.
If you're using SpiraPlan, then you can also check the article KB727 - Extracting Custom List value names using OData.

In case you're still not able to get the values as desired, please share the full query so we can check exactly what you see.

 

Regards,
Victoria -

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Friday, January 16, 2026
  • Last Reply: Tuesday, January 20, 2026
  • Replies: 3
  • Views: 77