It depends on what object overlay you delete. From what you describe it sounds like you are talking about deleting an overlaid view; true if you delete the overlay view the column is still in the db. The scenarios I was talking is right clicking the form and selecting "Delete". If the form has an overlay layer it will delete fields that were created in the overlay layer. If the form did not have an overlay layer then the form is deleted; both being triggered by right clicking the form -> "Delete."
In the scenario where you are deleting a form overlay the column in the db is removed. I ran a few tests last night before replying since I am still adjusting to developing on a system with overlays (admittedly I haven't deleted many objects on a 7.6.04 system). Steps to test: 1. Created a new form as Unmodified (represents a BMC supplied form) 2. Created an overlay of the form 3. Created an overlay of the view 4. Verified there were only the 8 core columns in the T table 5. Created new field 6. Verified the new column was added to the T table 7. Deleted the form overlay (right click form -> delete) 8. Verified that the new column was removed from the T table. Jason On Thu, Jan 5, 2012 at 9:37 AM, Sanford, Claire < [email protected]> wrote: > ** > > Your customizations are “gone” but not really gone. **** > > ** ** > > If you added a field, it is still there. Just not on the form. At least > this has been my experience. What you lose is your formatting.**** > > ** ** > > I agree. I have cringed every time I have deleted an overlay. I worry > that I may do something wrong (even though BMC tells me to do it) and lose > something.**** > > ** ** > > Claire**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Kemes, Lisa > *Sent:* Thursday, January 05, 2012 8:18 AM > > *To:* [email protected] > *Subject:* Re: Created Overlay by Mistake**** > > ** ** > > ** **** > > Thanks Jason, that was my next question, if you delete and overlay with > lots of new changes, do they get lost as well. (I know stupid question but > just wanted to make sure). **** > > **** > > And I do remember Joe emailing me offline a couple of weeks ago and > telling me to delete an overlay that I created for testing just for fun (to > get used to it). It's but like Jason says, it just goes against my nature > to Delete a form! :) **** > > **** > > Thanks Everyone!!!**** > > Lisa **** > > **** > > ** ** > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Jason Miller > *Sent:* Thursday, January 05, 2012 1:32 AM > *To:* [email protected] > *Subject:* Re: Created Overlay by Mistake**** > > ** **** > > That is a bit of a general statement :) If you had considerable time > invested in your overlay and delete it you have still lost > the customizations/extensions and data in overlaid fields.**** > > ** ** > > My concern is that the word Delete has different range of ramifications > depending on what type of object you are deleting. If you delete an > Unmodified or Custom form it is gone and the data (T/H/B tables) and > non-shared workflow went with it. If you delete a Overlay form then you > obviously lose data in any fields you added (if you added data fields, you > may overlay a form just for view adjustments) but no workflow objects are > deleted. **** > > ** ** > > Maybe it is just one of those things you learn to never accidentally do > again after it happens the first time.**** > > ** ** > > Jason**** > > On Wed, Jan 4, 2012 at 6:42 PM, Joe Martin D'Souza <[email protected]> > wrote:**** > > ** **** > > **** > > That’s what I like about overlays.. You can afford these mistakes and > nothing would be lost. I agree it was a bit of an ‘adventure’ the first > time you ‘delete’ it – cross fingers and hope it works – that sort of thing > :-)**** > > **** > > Joe**** > > **** > > *From:* Jason Miller <[email protected]> **** > > *Sent:* Wednesday, January 04, 2012 7:58 PM**** > > *Newsgroups:* public.remedy.arsystem.general**** > > *To:* [email protected] **** > > *Subject:* Re: Created Overlay by Mistake**** > > **** > > ** LOL, I was trying to figure this out last week until I remember you > delete the overlaid object and it will change back to unmodified. I had a > little issue with the concept "delete" in this context actually meaning > restore to unmodified. **** > > **** > > It does seem there is potential for mistakes in conditioning developers to > "Delete" to remove an overlay. Sounds like an enhancement request; to > adjust the text for the delete option based on the object's Customization > Type. **** > > **** > > Jason**** > > On Wed, Jan 4, 2012 at 1:59 PM, Easter, David <[email protected]> > wrote:**** > > ** **** > > Just delete the overlay.**** > > **** > > -David J. Easter**** > > Manager of Product Management, Remedy Platform**** > > BMC Software, Inc.**** > > **** > > The opinions, statements, and/or suggested courses of action expressed in > this E-mail do not necessarily reflect those of BMC Software, Inc. My > voluntary participation in this forum is not intended to convey a role as a > spokesperson, liaison or public relations representative for BMC Software, > Inc.**** > > **** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Kemes, Lisa > *Sent:* Wednesday, January 04, 2012 1:49 PM > *To:* [email protected] > *Subject:* Created Overlay by Mistake**** > > **** > > ** **** > > I created an overlay on a form and didn't mean to create a overlay on that > form.**** > > **** > > Is there a way to make it go back to "Unmodified?"**** > > **** > > *Lisa Kemes***** > > AR System Developer > TEIS - USA**** > > +1 717 810 2408 <%2B1%20717%20810%202408> tel > +1 717 602 9460 mobile > *[email protected]* > 100 Amp Drive**** > > Harrisburg, PA 17112 > > > > *www.te.com* > > **** <http://www.te.com/> > > **** > > _attend WWRUG12 *www.wwrug.com* ARSlist: "Where the Answers Are"_ **** > > _attend WWRUG12 *www.wwrug.com* ARSlist: "Where the Answers Are"_ **** > > **** <http://www.te.com/> > > _attend WWRUG12 *www.wwrug.com* ARSlist: "Where the Answers Are"_ > ****<http://www.te.com/> > > _attend WWRUG12 *www.wwrug.com* ARSlist: "Where the Answers Are"_ > ****<http://www.te.com/> > > ** ** <http://www.te.com/> > > _attend WWRUG12 *www.wwrug.com* ARSlist: "Where the Answers Are"_ > ****<http://www.te.com/> > > _attend WWRUG12 *www.wwrug.com* ARSlist: "Where the Answers Are"_ > ****<http://www.te.com/> > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
