Inflectra Customer Forums: Custom Query Help (Thread) Hi, I've written the following custom query but am having trouble getting the Count values for my requirments and incidents, as what is returned is ' System.Data.Query.ResultAssembly.BridgeDataReader' instead of an integer value. Any idea how I can get this to work? Thank you! select R.CUST_05 AS IMPLEMENTATION_DATE, R.PROJECT_NAME, R.NAME AS RELEASE_NAME, R.RELEASE_ID, R.TASK_ESTIMATED_EFFORT AS ESTIMATED_EFFORT, R.TASK_ACTUAL_EFFORT AS ACTUAL_EFFORT, (select value count(S.INCIDENT_ID) from SpiraTestEntities.R_Incidents as S where S.DETECTED_RELEASE_ID = R.RELEASE_ID) AS INCIDENT_COUNT, (select value count(Q.REQUIREMENT_ID) from SpiraTestEntities.R_Requirements as Q where R.RELEASE_ID = Q.RELEASE_ID && (NOT Q.IS_DELETED) && (Q.IMPORTANCE_ID = 1) && (NOT(Contains(Q.DESCRIPTION, 'AUDIT')))) AS REQUIREMENT_COUNT from SpiraTestEntities.R_Releases as R where (R.PROJECT_GROUP_ID = 19) && (R.ACTIVE_YN = 'Y') && (Cast(R.CUST_05 as DateTime) BETWEEN AddDays(CurrentDateTime(), -7) AND AddDays(CurrentDateTime(), 0)) order by R.PROJECT_NAME, RELEASE_NAME en-US(C) Copyright 2006-2024 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/issues-questions/562.aspxthreadId=562Vanessa Smith (vanessa.smith@flhosp.org)Custom Query Help Hi, I've written the following custom query but am having trouble getting the Count values for my requirments and incidents, as what is returned is ' System.Data.Query.ResultAssembly.BridgeDataReader' instead of an integer value. Any idea how I can get this to work? Thank you! select R.CUST_05 AS IMPLEMENTATION_DATE, R.PROJECT_NAME, R.NAME AS RELEASE_NAME, R.RELEASE_ID, R.TASK_ESTIMATED_EFFORT AS ESTIMATED_EFFORT, R.TASK_ACTUAL_EFFORT AS ACTUAL_EFFORT, (select value count(S.INCIDENT_ID) from SpiraTestEntities.R_Incidents as S where S.DETECTED_RELEASE_ID = R.RELEASE_ID) AS INCIDENT_COUNT, (select value count(Q.REQUIREMENT_ID) from SpiraTestEntities.R_Requirements as Q where R.RELEASE_ID = Q.RELEASE_ID && (NOT Q.IS_DELETED) && (Q.IMPORTANCE_ID = 1) && (NOT(Contains(Q.DESCRIPTION, 'AUDIT')))) AS REQUIREMENT_COUNT from SpiraTestEntities.R_Releases as R where (R.PROJECT_GROUP_ID = 19) && (R.ACTIVE_YN = 'Y') && (Cast(R.CUST_05 as DateTime) BETWEEN AddDays(CurrentDateTime(), -7) AND AddDays(CurrentDateTime(), 0)) order by R.PROJECT_NAME, RELEASE_NAME Wed, 17 Apr 2013 15:17:45 -04002013-04-18T19:58:28-04:00/Support/Forum/spirateam/issues-questions/562.aspxmessageId=1041Vanessa Smith (vanessa.smith@flhosp.org) Follow-up: I got this to work by adding ANYELEMENT as a wrapper to my query. For example: AN Follow-up: I got this to work by adding ANYELEMENT as a wrapper to my query. For example: ANYELEMENT(select value count(Q.REQUIREMENT_ID) from SpiraTestEntities.R_Requirements as Q where R.RELEASE_ID = Q.RELEASE_ID && (NOT Q.IS_DELETED) && (Q.IMPORTANCE_ID = 1) && (NOT(Contains(Q.DESCRIPTION, 'AUDIT')))) AS REQUIREMENT_COUNT returns me a value of 11, which is correct! Thu, 18 Apr 2013 18:05:48 -04002013-04-18T18:05:48-04:00/Support/Forum/spirateam/issues-questions/562.aspx#reply1041messageId=1042David J (support1@inflectra.com) Thanks for reposting the query with the answer. Thanks for reposting the query with the answer.Thu, 18 Apr 2013 19:58:28 -04002013-04-18T19:58:28-04:00/Support/Forum/spirateam/issues-questions/562.aspx#reply1042