Hi, I'm trying to build a querry which will extract all incidents for a project which were raised by members of the same department. I was able to create some of the pieces of the querry (see below) but I am not able to put them together into a single querry so that I get the report I'm after. Anyone able to provide some help with this? select value R from SpiraTestEntities.R_Incidents as R where R.PROJECT_ID = ${ProjectId} select value R from SpiraTestEntities.R_Incidents as R where R.OWNER_ID = 'Tom' select R.USER_ID from SpiraTestEntities.R_Users as R where R.DEPARTMENT= 'ICT' I am able to select the incidents by user and the users which are part of the ICT department, however I don't know how to combine it all together. Thanks for any help. 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/spirateam/issues-questions/718.aspxthreadId=718Thomas Toth (fsh-spirateam@serco-ap.com.au) Hi, I'm trying to build a querry which will extract all incidents for a project which were raised by members of the same department. I was able to create some of the pieces of the querry (see below) but I am not able to put them together into a single querry so that I get the report I'm after. Anyone able to provide some help with this? select value R from SpiraTestEntities.R_Incidents as R where R.PROJECT_ID = ${ProjectId} select value R from SpiraTestEntities.R_Incidents as R where R.OWNER_ID = 'Tom' select R.USER_ID from SpiraTestEntities.R_Users as R where R.DEPARTMENT= 'ICT' I am able to select the incidents by user and the users which are part of the ICT department, however I don't know how to combine it all together. Thanks for any help. Fri, 20 Sep 2013 02:04:21 -04002013-10-03T06:09:59-04:00/Support/Forum/spirateam/issues-questions/718.aspxmessageId=1306David J (adam.sandman+support@inflectra.com) Hi Thomas Something like: select value R from SpiraTestEntities.R_Incidents as R where R.PROJECT_ID = ${ProjectId} and R.OWNER_ID = 'Tom' and R.DEPARTMENT = 'ICT' Regards Adam Tue, 24 Sep 2013 15:26:06 -04002013-09-24T15:26:06-04:00/Support/Forum/spirateam/issues-questions/718.aspx#reply1306messageId=1311Thomas Toth (fsh-spirateam@serco-ap.com.au) Sorry for the late feedback, I only saw your reply today. Unfortunately that doesn't work as R_Incidents doesn't have R.REPARTMENT in it. I need to find a way to join the two tables based on the user_id. I get the error message 'DEPARTMENT' is not a member of type 'Inflectra.SpiraTest.DataModel.R_Incident' in the currently loaded schemas. Near simple identifier, line 1, column 86'. Thu, 03 Oct 2013 06:09:59 -04002013-10-03T06:09:59-04:00/Support/Forum/spirateam/issues-questions/718.aspx#reply1311