I can't use select inside select in my query! As an example: select R.name as NAME, R.DESCRIPTION, (select E.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? en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spiratest/issues-questions/1254.aspxthreadId=1254Teemu Karvinen (teemu.karvinen@s-factory.fi)reporting I can't use select inside select in my query! As an example: select R.name as NAME, R.DESCRIPTION, (select E.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? Fri, 17 Jul 2015 07:07:22 -04002015-07-27T09:40:35-04:00/Support/Forum/spiratest/issues-questions/1254.aspxmessageId=2249David J (adam.sandman+support@inflectra.com) Hi Teemu I would use a join rather than sub-select as illustrated here: https://www.inflectra.com/Support/KnowledgeBase/KB74.aspx Regards Adam Tue, 21 Jul 2015 14:43:19 -04002015-07-21T14:43:19-04:00/Support/Forum/spiratest/issues-questions/1254.aspx#reply2249messageId=2251Teemu Karvinen (teemu.karvinen@s-factory.fi) Thanks! I got it working with join. Wed, 22 Jul 2015 05:24:44 -04002015-07-22T05:24:44-04:00/Support/Forum/spiratest/issues-questions/1254.aspx#reply2251messageId=2257Teemu Karvinen (teemu.karvinen@s-factory.fi)Hi! 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: Project Group : but I don't know where this select is so it could be edited. Is there something I should change in 'match="/ProjectData/Project"'? Mon, 27 Jul 2015 09:40:35 -04002015-07-27T09:40:35-04:00/Support/Forum/spiratest/issues-questions/1254.aspx#reply2257