One caveat to this, whenever you put a view on top of the 'fields' table, you'll note that there isn't a unique key field.
For instance, each regular remedy form you have has a field 1. So, if you make field 1 the key, then you do a search against field 1, your results list will show all of the field 1s, but as you click on each row in the results list, you will only see the first field 1 that it finds displayed in the details pane. This is because each time you click on a row in the results list, remedy queries again, and pulls back the first matching ticket. If you set the schema as the unique key, then you can search by field 1 and get the expected results. However, if you search by schema id, then you'll se the above behaviors, only it will be schema-centric. You can still use this, just make sure all of your searches reference both Schema ID and Field ID. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Friday, September 21, 2007 6:11 AM To: [email protected] Subject: Re: How to get the form and field names? ** Try building View forms against the underlying Remedy metadata. Then use those View forms in table fields. You could even build a database view of the data you need then use that view in a View form which could then be tied to a table. Some Remedy tables of interest: field arschema On 9/21/07, Mark Milke <[EMAIL PROTECTED]> wrote: Hi everyone, I'd like to build a configurable application, where the admin can can configure/enable different functions for certain part of the application. I was wondering how to access form and field name and field ids. Acctualy I'd need to show them in a table field. As far as I know there is no other way to do to build a dictionary with all the form and field data. Does anyone have a script do populate a form with the form, field names and ids? Mark ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
