Skip Navigation LinksForums > SpiraTest Forums > SpiraTest Issues & Questi... > Custom Query report probl...

Custom Query report problem RSS Feed

Friday, July 17, 2015
I can't use select inside select in my query!

As an example:
select as NAME, 
    from SpiraTestEntities.R_CustomListValues as E 
    join SpiraTestEntities.R_Incidents as A on A.PROJECT_ID = E.PROJECT_ID 
    where A.CUST_03 = cast(E.CUSTOM_PROPERTY_VALUE_ID as string) and E.CUSTOM_PROPERTY_LIST_ID = 11) as AREA 
from SpiraTestEntities.R_Incidents as R 
where R.PROJECT_GROUP_ID = ${ProjectGroupId}

This query gives AREA as System.Data.Query.ResultAssembly.BridgeDataReader and all other fields as they should.
Both selects work when not combined. 
I have to make a query with 2 of these selects inside a select to get values in place of IDs. 

How is one suposed to get actual values into a report when using multiple custom fields?
3 Replies
Adam SAdam S
re: Teemu Karvinen on Friday, July 17, 2015
Tuesday, July 21, 2015
Hi Teemu

I would use a join rather than sub-select as illustrated here:


Teemu KarvinenTeemu Karvinen
re: Adam S on Tuesday, July 21, 2015
Wednesday, July 22, 2015

I got it working with join.
Teemu KarvinenTeemu Karvinen
re: Teemu Karvinen on Wednesday, July 22, 2015
Monday, July 27, 2015

I can't get project name in top of my report to change to project group name.
Is that possible?

I tryed to edit Standard Section like this: 

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="" xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
<xsl:template match="/ProjectData/Project">
<div class="Title1">Project Group <xsl:value-of select="ProjectGroupId"/>: <xsl:value-of select="Name"/></div>
<xsl:value-of select="Description" disable-output-escaping="yes"/>

but I don't know where this select is so it could be edited. Is there something I should change in 'match="/ProjectData/Project"'?

  • Started: 7/17/2015
  • Last Reply: 7/27/2015
  • Replies: 3
  • Views: 366
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.