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"
BEGIN:VCARD VERSION:2.1 N:Davis;David FN:Davis, David CTR NAVSURFWARCENDIV Crane, Code 0552 ORG:USN Contractor;SAIC TITLE:CONT TEL;WORK;VOICE:(812) 854-2150 TEL;HOME;VOICE:(812) 847-7204 TEL;CELL;VOICE:(812) 384-6456 ADR;WORK:;Bld 3173, Code 0552;300 Highway 361;Crane;IN;47522-5000;UNITED STATES LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Bld 3173, Code 0552=0D=0A300 Highway 361=0D=0ACrane, IN 47522-5000=0D=0AUNIT= ED STATES EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20061011T155306Z END:VCARD
