In 7.x the form's view is stored in the arschema table for any form created/modified since the upgrade to 7.x
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of RFrench Sent: Friday, December 19, 2008 6:40 AM To: arslist@ARSLIST.ORG Subject: Re: Getting the Current Form Name If you have a look at this thread it will give you some more information http://n2.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-st ructure-tt1562658.html#none http://n2.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-st ructure-tt1562658.html#none I am not sure if it is possible to take the name of a form and create a query to list the view name. However the form name is very close to the view that the data is stored in. This is what the database reference says about form and view names SQL views For each table that is built in the system (except for the attachment tables), an SQL view is automatically created. This view uses the form name as the view name and the field names (not a display label in one of the views) as the column names. The names are created by using the following rules: All alphabetic and numeric characters remain as defined. All other characters are converted to an underscore (_). If the first character is not alphanumeric, a leading A is added to the name. If the name of a field is blank, a field name with a leading A followed by the fieldId is used. If the name is one of the reserved words for the database, the string _x is appended. -- View this message in context: http://www.nabble.com/Getting-the-Current-Form-Name-tp21037113p21091452.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
