Trying to query the organization field in the R_Users table

Tuesday, January 12, 2021

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 doesn't 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'}

3 Replies
Wednesday, January 13, 2021
re: gwydenbach Tuesday, January 12, 2021


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:



Wednesday, January 13, 2021
re: inflectra.david Tuesday, January 12, 2021

Yes, I already checked that documentation. It does not include the organization table.

Wednesday, January 13, 2021
re: gwydenbach Wednesday, January 13, 2021

I mean the organization field in the user table.

  • Started: Tuesday, January 12, 2021
  • Last Reply: Wednesday, January 13, 2021
  • Replies: 3
  • Views: 554