I don’t think it will be an issue as such in this particular case. The object he is creating in the base mode is an object that did not already exist on the form. So it’s a new object altogether, and not a customization of an existing object as such.
This is my theory about how it could work.. Create that field in the base mode and create that unique index necessary for it. Take it out of all views. Return to Best Practice mode. Overlay the views you want to add that field to, and add that field to those views.. This way it should not technically bugger up an upgrade.. I may be wrong, but its something that sounds right theoretically. You could try in a test environment, on lets say ITSM 7.6.04 on a form that’s changed on SP1, and then upgrade to SP1 and check out the impact of an upgrade.. Joe From: Guillaume Rheault Sent: Friday, November 04, 2011 11:21 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Adding a Unique Index to COM:Company ** I would not recommend that... next time he upgrades, he may run into issues, since that is an "invalid" customization. Guillaume -------------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Melissa reed [melissa.r...@stls.frb.org] Sent: Thursday, November 03, 2011 4:57 PM To: arslist@ARSLIST.ORG Subject: Re: Adding a Unique Index to COM:Company ** You can create the unique index on the base form, when you take it out of best practice mode. From: "Cecil, Ken" <kce...@hubbell.com> To: arslist@ARSLIST.ORG Date: 11/03/2011 03:55 PM Subject: Re: Adding a Unique Index to COM:Company Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> -------------------------------------------------------------------------------- ** Just to confirm I checked and creating more than one unique index on COM:Company in 7.5.x was no problem. So yeah, must be an overlay limitation as Guillaume reported. Ken. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Guillaume Rheault Sent: Thursday, November 03, 2011 4:15 PM To: arslist@ARSLIST.ORG Subject: Re: Adding a Unique Index to COM:Company ** Hi Jase, I am 99.9999% sure you cannot create a unique index on an overlaid form, that is a known limitation... You can only create unique indexes on custom forms. So the only thing you can do is create two filters that fire on submit and modify: 1st one checks whether the value is already present in another record in teh same form 2nd props the error message cheers Guillaume -------------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Jase Brandon [jasebran...@gmail.com] Sent: Thursday, November 03, 2011 4:08 PM To: arslist@ARSLIST.ORG Subject: Adding a Unique Index to COM:Company ** Hello All, I need to add a unique index to the COM:Company form to ensure that a custom field maintains a distinct value on submit. But.... there is already a unique index on the Request ID field on COM:Company, and dev studio won't give me the option to add another unique index on the field I want. I thought "oh yeah - only one unique index per form", then for jokes n' grins - I checked HPD:HelpDesk - which has two unique indexes, both character indexes. So that proves more than one unique index is available per form. What am I doing wrong? Any suggestions from the gang? :-) FYI... COM:Company is already overlaid as well as the view I'm working with. Thanks in Advance, Jase Brandon 7.6.04 SP1 Windows 2008 _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ ******************************************************************* This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.com - Hubbell Incorporated** _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _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"