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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
