Inflectra Customer Forums: Trying to query the organization field in the R_Users table (Thread) 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-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/2347.aspxthreadId=2347Graham Wydenbach (gwydenbach@stayinfront.com)Trying to query the organization field in the R_Users table 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 (support1@inflectra.com) Hi You can see all information about all custom report tables on our documentation site. The entry 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. 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. 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