Does anyone know where this field is stored? Its not in the r_users table. I thought it might be in the custom properties table but it doesnt appear to be there either. I am trying to bring back the organization field in a query for a report. In this query I am using the department field from r_users but I really want the organization field: select U.department, R.PROJECT_NAME as Project, R.INCIDENT_ID as Defect_ID, R.CREATION_DATE as Date_Added, R.LAST_UPDATE_DATE as Last_Updated, R.PRIORITY_NAME as Priority, R.SEVERITY_NAME as Severity, R.INCIDENT_STATUS_NAME as Status, R.INCIDENT_TYPE_NAME as Defect_Type, R.OPENER_NAME as Added_By, R.OWNER_NAME as Assigned_To, R.NAME as Summary from SpiraTestEntities.R_Incidents as R join SpiraTestEntities.R_Users as U on R.OWNER_ID = U.USER_ID where R.PROJECT_ID in {7, 8, 13, 14, 20, 21, 25, 11, 23, 24, 35, 36, 37, 39, 40, 41, 42, 55, 61, 62, 73} and R.INCIDENT_STATUS_NAME NOT in {Resolved, Duplicate, Closed, No action required, Non Defect, Non Defect Advised, Can Not Replicate, Cancelled, Deferred Advised, Deferred Recommended, Pass, Pending, QA Pass, QA-Pass, Rejection Accepted, Rejection Declined, Spec Update, UAT Passed, UAT-Pass, Rejected} 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/2347.aspxthreadId=2347Graham Wydenbach (gwydenbach@stayinfront.com) Does anyone know where this field is stored? Its not in the r_users table. I thought it might be in the custom properties table but it doesnt appear to be there either. I am trying to bring back the organization field in a query for a report. In this query I am using the department field from r_users but I really want the organization field: select U.department, R.PROJECT_NAME as Project, R.INCIDENT_ID as Defect_ID, R.CREATION_DATE as Date_Added, R.LAST_UPDATE_DATE as Last_Updated, R.PRIORITY_NAME as Priority, R.SEVERITY_NAME as Severity, R.INCIDENT_STATUS_NAME as Status, R.INCIDENT_TYPE_NAME as Defect_Type, R.OPENER_NAME as Added_By, R.OWNER_NAME as Assigned_To, R.NAME as Summary from SpiraTestEntities.R_Incidents as R join SpiraTestEntities.R_Users as U on R.OWNER_ID = U.USER_ID where R.PROJECT_ID in {7, 8, 13, 14, 20, 21, 25, 11, 23, 24, 35, 36, 37, 39, 40, 41, 42, 55, 61, 62, 73} and R.INCIDENT_STATUS_NAME NOT in {Resolved, Duplicate, Closed, No action required, Non Defect, Non Defect Advised, Can Not Replicate, Cancelled, Deferred Advised, Deferred Recommended, Pass, Pending, QA Pass, QA-Pass, Rejection Accepted, Rejection Declined, Spec Update, UAT Passed, UAT-Pass, Rejected} Tue, 12 Jan 2021 15:46:21 -05002021-01-13T13:50:16-05:00/Support/Forum/spirateam/issues-questions/2347.aspxmessageId=3909David J (adam.sandman+support@inflectra.com) Hi You can see all information about all custom report tables on our documentation site. The entry for the user table you are after is here: http://spiradoc.inflectra.com/Reporting/Custom-Report-Tables/#users Best, David Wed, 13 Jan 2021 01:14:11 -05002021-01-13T01:14:11-05:00/Support/Forum/spirateam/issues-questions/2347.aspx#reply3909messageId=3910Graham Wydenbach (gwydenbach@stayinfront.com) Yes, I already checked that documentation. It does not include the organization table. Wed, 13 Jan 2021 13:49:49 -05002021-01-13T13:49:49-05:00/Support/Forum/spirateam/issues-questions/2347.aspx#reply3910messageId=3911Graham Wydenbach (gwydenbach@stayinfront.com) I mean the organization field in the user table. Wed, 13 Jan 2021 13:50:16 -05002021-01-13T13:50:16-05:00/Support/Forum/spirateam/issues-questions/2347.aspx#reply3911