Sigh. I messed up one of my reports ..

Thursday, December 8, 2016 4:07:56 PM
Hi

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

BR,

Lene, Tryg Insurance

4 Replies
Thursday, December 8, 2016 5:18:47 PM
Avatar
re: Tryg on Thursday, December 8, 2016 4:07:56 PM
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 10:25:35 AM
Avatar
re: inflectra.adam on Thursday, December 8, 2016
I don't have a default query for Users.
Tuesday, December 20, 2016 8:22:55 AM
Avatar
re: Tryg on Friday, December 9, 2016
Can you please help me out here, Adam?
Thursday, December 22, 2016 5:20:04 PM
Avatar
re: Tryg on 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
Statistics
  • Started: Thursday, December 8, 2016 4:07:56 PM
  • Last Reply: Thursday, December 22, 2016 5:20:04 PM
  • Replies: 4
  • Views: 339