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"
