Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > Sigh. I messed up one of ...

Sigh. I messed up one of my reports ..

Thursday, December 8, 2016
reporting
Avatar
Hi

Can I have a list of the names of the fields in the User file, please?

BR,

Lene, Tryg Insurance
(To Reply to this thread you first need to Sign-In )
4 Replies
Thursday, December 8, 2016
Avatar
re: Tryg Thursday, December 8, 2016
Hi Lene

Just choose the default query for Users and click 'Preview' it will display all of the fields in the popup table...

Regards

Adam
Friday, December 9, 2016
Avatar
re: inflectra.david Thursday, December 8, 2016
I don't have a default query for Users.
Tuesday, December 20, 2016
Avatar
re: Tryg Friday, December 9, 2016
Can you please help me out here, Adam?
Thursday, December 22, 2016
Avatar
re: Tryg Tuesday, December 20, 2016
Hi Lene

Just use this query:

select value R from SpiraTestEntities.R_Users as R

That gives:

USER_ID    USER_NAME    EMAIL_ADDRESS    IS_ACTIVE    CREATION_DATE    LDAP_DN    FIRST_NAME    LAST_NAME    MIDDLE_INITIAL    DEPARTMENT    LAST_UPDATE_DATE    TIMEZONE    LAST_OPENED_PROJECT_ID

Regards

Adam

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 
Statistics
  • Started: Thursday, December 8, 2016
  • Last Reply: Thursday, December 22, 2016
  • Replies: 4
  • Views: 8702
Tel: 1-866-572-5878 | Help Desk | Legal Notices | Privacy Policy
Powered by KronoDesk v4.0.1 help desk software | © Copyright 2006-2024 | Licensed to Inflectra Corporation.