Inflectra Customer Forums: Sigh. I messed up one of my reports .. (Thread) Hi Can I have a list of the names of the fields in the User file, please? BR, Lene, Tryg Insurance en-US(C) Copyright 2006-2024 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/1589.aspxthreadId=1589Test Management (QualityAssurance@tryg.dk)Sigh. I messed up one of my reports .. Hi Can I have a list of the names of the fields in the User file, please? BR, Lene, Tryg Insurance Thu, 08 Dec 2016 16:07:56 -05002016-12-22T17:20:04-05:00/Support/Forum/spirateam/reports/1589.aspxmessageId=2839David J (support1@inflectra.com) Hi Lene Just choose the default query for Users and click 'Preview' it will display all of the fi 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 Thu, 08 Dec 2016 17:18:47 -05002016-12-08T17:18:47-05:00/Support/Forum/spirateam/reports/1589.aspx#reply2839messageId=2845Test Management (QualityAssurance@tryg.dk) I don't have a default query for Users. I don't have a default query for Users.Fri, 09 Dec 2016 10:25:35 -05002016-12-09T10:25:35-05:00/Support/Forum/spirateam/reports/1589.aspx#reply2845messageId=2849Test Management (QualityAssurance@tryg.dk) Can you please help me out here, Adam? Can you please help me out here, Adam?Tue, 20 Dec 2016 08:22:55 -05002016-12-20T08:22:55-05:00/Support/Forum/spirateam/reports/1589.aspx#reply2849messageId=2855David J (support1@inflectra.com) Hi Lene Just use this query: select value R from SpiraTestEntities.R_Users as R That gives: 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 Thu, 22 Dec 2016 17:20:04 -05002016-12-22T17:20:04-05:00/Support/Forum/spirateam/reports/1589.aspx#reply2855