Actually I was doing this on an application we purchased from Column Technologies and I added a couple of dozen fields and can't find any of them on the View. I find them on the T table just not the view. I figured it would cause less questions if I used CTM:People as my example since I did add about 5 fields there and they are not showing either. Straight from BMC Support: Below are my findings on this issue. 1. Currently we do not have a view in which the field on the overlay form is stored as it may hamper the AR Server Performance. 2. Kindly pick up the field on the basis of its 'field id' from the <field> and the <field_char> table. All the fields in the AR System are listed in these tables. select * from field where fieldname = <fieldname> select * from field_char where fieldid = <fieldid> 3. select * from field where schemaid=<schema_id> output: this will display all the fields on the form with schemaid <schema_id> together with the properties of the fields and customized field added would be included in this table 4. You can also refer view 'AR_System_Metadata__field' to get more information about the fields created in AR System.
________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Matt Reinfeldt Sent: Thursday, July 21, 2011 11:01 AM To: [email protected] Subject: Re: Overlay and Database Views - Answer ** Christie, Strangely enough.... I built a form in Base mode.... then switched to best practice mode and added a field. The form then properly showed as 'Overlaid'. I opened up SQL Management tool (sql server 2005) and looked at the available columns in the view that was auto-generated for that form. The new field (the one created in the overlay) was present. So, it's interesting to me if it doesn't work for the OOB ITSM forms. Must be some other magic going on. :-) Enjoy, Matt R. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Pargeter, Christie :CO IS Sent: Thursday, July 21, 2011 11:56 AM To: [email protected] Subject: Re: Overlay and Database Views - Answer ** Found out from BMC that there isn't a view with the overlay fields in it. ________________________________ From: Pargeter, Christie :CO IS Sent: Monday, July 18, 2011 12:58 PM To: '[email protected]' Subject: Overlay and Database Views Hi All - does anyone know what the view names are for the fields added to an overlay? e.g., I added a field to CTM:People and I need to write a SQL query to access that data. Normally I would use the view to do this so that my query is the same on all environments. But when I look in the database I am not seeing the new field. Thanks ARS 7.6.4 SQL 2005 ________________________________ Christie Pargeter Legacy Health IS - Programming SR Technical Analyst [email protected] 1120 Building tel: 503-415-5149 _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
