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?