Hi Jason,
I certainly recall many view generation failures at least until 7.6.04. Back then if a view generation failed it did not throw an error. That may still be the case. Only if you used the views would you discover something amiss. The viewname column was added to arschema in 7.1. Prior to that if you needed a table’s viewname, you’d have to follow a DB dependent algorithm to generate it using the name and schemaid. I’ve asked for a couple of queries to see what the view looks like. Cheers, Ben From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Jason Miller Sent: January-31-18 8:57 AM To: ARSList <arslist@arslist.org> Subject: Re: FYI: Duplicate Field Names in 9.1.00 201512160229 possible A bit OT but I do remember a time when you could name a field with a DB keyword and the SQL view would not be generated. I Remember we a few forms with the field call "function" and the SQL view wouldn't build until we got smart and started naming the field something like "functionx". I think the last time I saw this was like in 6.x, maybe even 5.x. Jason On Wed, Jan 31, 2018 at 9:37 AM, Ben Chernys <ben.cher...@softwaretoolhouse.com <mailto:ben.cher...@softwaretoolhouse.com> > wrote: 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:arslist-boun...@arslist.org <mailto:arslist-boun...@arslist.org> ] On Behalf Of LJ LongWing Sent: January-31-18 8:06 AM To: ARSList <arslist@arslist.org <mailto:arslist@arslist.org> > 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.cher...@softwaretoolhouse.com <mailto:ben.cher...@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 Canada / Deutschland Mobile: +49 171 380 2329 <tel:+49%20171%203802329> GMT - 7 + [ DST ] Mobile +1 403 <tel:(403)%20554-0887> 554 0887 Email: Ben.Chernys_AT_softwaretoolhouse.com <mailto:Ben.Chernys_AT_softwaretoolhouse.com> Web: <http://www.softwaretoolhouse.com/> 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/> http://www.softwaretoolhouse.com/ -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist
-- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
