Mark,
Try this on your SQL client: Select fieldId, fieldName from field where scheamId in (select scheamId from arschema where name = 'Name of Form Case Sensitive'); You can add as many clauses to where to filter the type of fields you want to list in case you want to list only certain types of field. You could output this result to a file if you want a document. The field labels are stored in the view definition Cheers Joe _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Tuesday, January 08, 2013 9:45 AM To: arslist@ARSLIST.ORG Subject: Getting list of fields Hi All, This is probably so simple I shouldn't be asking. Is there a way to generate a list of field labels, db name and db id's. I can display the list in Developer using the form outline and can do a select all. However I cannot do a copy paste or print this information. Am I missing something. ARS 7.6.04 SP3 Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-882.5360 _____ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
