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] <mailto:[email protected]> 1120 Building tel: 503-415-5149 _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"
