well, the obvious thing is to change one to a different name and hit save, then try to change it back...which it won't allow....I, like you, have no idea how they would have gotten into that situation in the first place.
On Thu, Feb 1, 2018 at 11:10 AM, Ben Chernys < [email protected]> wrote: > The 9.1.04 Dev Studio does *not* permit a duplicate field name to be > entered. Dev Studio is enhanced so that a red small msg is displayed > saying duplicate field – nice improvement over only replacing your typing > with what was there before. > > > > I note that I tried this on a regular form. Perhaps there are some > special rules on a join? No matter how (though I am curious), they do have > a duplicate field name: > > > > HPD:IncidentInterface > > 536870923 > > Last Resolved Date > > HPD:IncidentInterface > > 1000000563 > > Last Resolved Date > > > > It looks like they put it in as one field id and then decided using the > BMC field id was better. If they have “matching fields” or even shared > workflow, they would still work if the BMC field was the populated one. > > > > Interestingly, the *view was created *with both fields by appending “001” > and “002”. I do not know which is which. I’d expect it to be in Id order > but it could also be in when created order. > > > > Last_Resolved_Date001 > > Last_Resolved_Date002 > > > > Which begs the question: will BMC add a viewname column to arfield as > well? (It would be nice.) How was one to expect the above two view column > names from the field names that ARS knows about? (ie what order?). > > > > And how was the inclusion of two identically named fields possible? I > could not do it with the 8.0.0 and 9.1.04 Dev Studio. > > > > The fact that there is code for handling duplicate fields when generating > a view presumably does not mean that this is a new direction for schemas > and fields – that duplicate named fields will be allowed? Besides, the > clients disallow it. > > > > Any responses from BMC would be most appreciated. > > > > Cheers > > Ben > > > > > > *From:* Ben Chernys [mailto:[email protected]] > *Sent:* January-31-18 8:38 AM > *To:* 'ARSList' <[email protected]> > *Subject:* RE: FYI: Duplicate Field Names in 9.1.00 201512160229 possible > > > > As I said, “I’m curious as to what field names were generated for the > view.” > > I have no idea how they got it done. I have an older dev studio and it > prevented that action from going to the server (as it should). Remember > that Remedy has code for generating a field’s viewname. There’s a couple > of fields in ITSM that have names ending in a space for example (xxx_ in > the view). A field could be a reserved word in the db. > > Cheers > Ben > > > > *From:* ARSList [mailto:[email protected] > <[email protected]>] *On Behalf Of *LJ LongWing > *Sent:* January-31-18 8:06 AM > *To:* ARSList <[email protected]> > *Subject:* Re: FYI: Duplicate Field Names in 9.1.00 201512160229 possible > > > > Ben, > > I'm not sure how exactly that can happen because the 'name', assuming we > are talking about the DB name of the field is used in the View creation, > and you obviously can't have two columns with the same name in the DB view, > so you can't do it in Dev Studio either...I would be curious to see a def > of the form in question....this hasn't been possible since I started using > remedy in v 3.2....not sure how they got it done. > > > > On Wed, Jan 31, 2018 at 7:55 AM, Ben Chernys <Ben.Chernys@ > softwaretoolhouse.com> wrote: > > Hi Folks, > > Just ran into an odd issue. A customer has created a field twice in the > same form with the same name (but different ids). I tried to do the same > on my 9.1.02 server using the 8.0 Developer Studio but the client prevented > a duplicate entry into the name field. I remember the old admin tool > returning a duplicate field error at some point. > > I’m curious as to what field names were generated for the view. > > All workflow is keyed to field ids so it is not surprising that the > Remedy application still functions – though I wonder which field is > selected in dev studio. I have downloaded the 9.1.04 clients et al and > will give its dev studio and RDP a try if I can put in a Java it thinks is > higher than 1.4 😊 > > Alas this is mere curiosity as Meta-Update/Meta-Archive is only affected > in that the field cache for this form is not used (a minor slow-down in > performance when dealing with this form). > > This is not a question; it just surprised me. > > Cheers, > > Ben Chernys > Senior Software Architect > [image: logoSthInc-sm] > > Canada / Deutschland > Mobile: +49 171 380 2329 <+49%20171%203802329> GMT - 7 + [ DST ] > > Mobile +1 403 554 0887 <(403)%20554-0887> > Email: Ben.Chernys_AT_softwaretoolhouse.com > Web: www.softwaretoolhouse.com > > We are a BMC Technology Alliance Partner > > > > > > Check out Software Tool House's free Diary Editor and our Freebies > Section for ITSM Forms and Fields spreadsheet. > > *Meta-Update <http://www.softwaretoolhouse.com/product/SthMupd/index.html>* > *,* our premium ARS Data tool, lets you automate your imports, > migrations, *in no time at all*, without programming, without staging > forms, without merge workflow. > > > > *Meta-Archive > <http://www.softwaretoolhouse.com/product/SthArch/index.html>* does ITSM > Archiving your way: with your forms and your multi-tenant rules, treating > each root request as a complete tree and checking associatuions. Archive > output to different servers, HTML pages with links to attachments or > archive forms. > > > > *Meta-Databot > <http://www.softwaretoolhouse.com/product/Databot/index.html>* is an > automated, extensible BMC Data Wizard. It reads a file of data changes and > sports an Undo feature. > > > > Pre ITSM 9.1.04? Clarify? HP? Roll your own? No problem! You can keep > your valuable data! > > > http://www.softwaretoolhouse.com/ > > > > > > > > > > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist > > > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist > >
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
