Here's a more up-to-date link: http://www.westoverconsulting.co.uk/utilitiesFF.html
David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Friday, September 21, 2007 5:00 PM To: [email protected] Subject: Re: How to get the form and field names? We've used the FormFields app from David Sanders for several years. You can find it at http://www.users.globalnet.co.uk/~sandersd/utilities.htm. It lists all forms, their fields, some field properties, and basic data type info. You can also search all forms for a particular field by either field name or field ID. It's driven by view forms so its always accurate and doesn't need updating. Very handy. I customized it a little further by adding the following features: - row count - table size (in MB) - number of fields - index listing - workflow listing - print/save form list - print/save field list - print/save field list with properties (crystal) - selectivity calculator (enter search criteria on any field and find % of matching records - very useful for report building and index analysis) This has made not only our own jobs much easier over the years but also anyone who has built reports or integrations into your Remedy system. Chad Hall (501) 342-2650 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Davis, David CTR NAVSURFWARCENDIV Crane, Code 0552 Sent: Friday, September 21, 2007 8:52 AM To: [email protected] Subject: Re: How to get the form and field names? Matt, Is this available as a developer Download or are you share the DEF file? Thank You, Dave Davis David J. Davis SAIC Senior Software Systems Engineer Crane Division, Naval Surface Warfare Center (NSWC Crane) Harnessing the Power of Technology for the Warfighter Code 0552, Bldg. 3173 300 Highway 361 Crane, IN 47522-5001 Ph: 812.854.2150 DSN: 482-2150 Fax: 812.854.3385 Email: [EMAIL PROTECTED] http://www.crane.navy.mil/custfeedback -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, September 21, 2007 8:37 To: [email protected] Subject: Re: How to get the form and field names? Mark, I have actually took the time to build an ARS form (not a view form) to hold this data. I then built a "Admin-Control Panel" to loop over the data and populate it. Yes, this means it is cached data that can become out of sync with the real meta-data that the ARS server uses. (but it is a simple "check box" to re sync them for me.) The advantages are: You have a totally portable ARS application to solve the problem You do not have to know much about the DB structures to put it together You could even run a nightly escalation to keep the data synced every 24 hours. (or just do it after any production change.) You do not have to "figure out" something that would work for a Request ID value. You can use this data to detect changes down to the field level and ask for documentation from developers for all changes. :) Disadvantages: Can be out of sync with reality Takes a bit of development work to put together (with some SQL in there too) HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 9/21/07, L. J. Head <[EMAIL PROTECTED]> wrote: > I created a view in the Db with this sql > > CREATE VIEW dbo.ExistingFields > AS > SELECT CAST(RTRIM(CAST(f.schemaId AS char)) + '' + > RTRIM(CAST(RIGHT(f.fieldId, 6) AS char)) AS int) AS RequestID, a.name > AS Form, a.schemaId AS FormID, > f.fieldName, f.fieldId, f.fieldType, f.datatype, > f.fOption, f.createMode, f.defaultValue > FROM dbo.arschema a INNER JOIN > dbo.field f ON a.schemaId = f.schemaId > > I then imported this view form on top of it. This allows me to lookup > fields and field ID's by form name or ID along with some basic > attributes about them...all of the cast for the request ID field is an > attempt to make a 15 char unique ID for the request ID. Hope it's > helpful to you ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ************************************************************************* The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. ************************************************************************* ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
