Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Qu... > Trying to query the organ...
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'}
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
Yes, I already checked that documentation. It does not include the organization table.
I mean the organization field in the user table.
And if you have any questions, please email or call us at +1 (202) 558-6885