Trying to query the organization field in the R_Users table

Tuesday, January 12, 2021
Avatar

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
Avatar
re: gwydenbach Tuesday, January 12, 2021

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

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

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

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

I mean the organization field in the user table.

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