Thread

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

Sigh. I messed up one of my reports .. RSS Feed

Thursday, December 8, 2016
Hi

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

BR,

Lene, Tryg Insurance

4 Replies
Adam SAdam S
re: Test Management on Thursday, December 8, 2016
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
Test ManagementTest Management
re: Adam S on Thursday, December 8, 2016
Friday, December 9, 2016
I don't have a default query for Users.
Test ManagementTest Management
re: Test Management on Friday, December 9, 2016
Tuesday, December 20, 2016
Can you please help me out here, Adam?
Adam SAdam S
re: Test Management on Tuesday, December 20, 2016
Thursday, December 22, 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
Tagged
Statistics
  • Started: 12/8/2016
  • Last Reply: 12/22/2016
  • Replies: 4
  • Views: 164
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2017 | Licensed to Inflectra Corporation.