Here 'tis.My addition to the Create {} subroutine is lines 130-138. The check for uniqueness and auto-choosing the next highest number happen in additional subroutines beginning at line 230.
We call the relevant field "COE Number" (sometimes "CoE Number", the case seems not to matter); change that wherever I have it to whatever you call your field.
Lines 133 and 137 are where I needed to know that the custom field was #1 ('CustomField-1'). There are two SELECT queries, one (line 322) where I searched for the field by name and one (line 244) where I searched for it by number. Probably I should have done both of those the same way, for clean code purposes. Probably searching by name would be the way to go, for even cleaner code purposes.
We assume that we'll be adding (whenever I get this live) existing assets to a clean database, so we accept input for the COE Number. I do some basic testing, to make sure that if there is input, it is a number and not, say, an SQL command. I don't do any sort of sanity checking on the given number, except to see if it's already in use; someone could, for instance, input "1000000" instead of "1000" and kick our asset numbers up a few orders of magnitude. Probably with some additional work the getNextNumber subroutine could look for such gaps and fill them in, but I don't think I'll be getting around to that extra work anytime soon.
I believe there are some rigorous tests that can be used on RT extensions; I have not done anything of that sort with this code. I've only played with it on a couple of test systems (both RT 4.2), but it so far does what I want it to.
If you have any questions, I'll try to answer, hopefully with something better than "It made sense at the time".
If any accomplished programmers would like to shred it and tell me everything I could do better, I'd appreciate the education.
Share and enjoy, Kyle On 03/15/2016 12:34 PM, Seever, Kenny wrote:
Kyle,Thanks for the reply. If possible would you be willing to share what you have? This will be something I’ve never attempted so need all the help I can get.Thanks again, Kenny *From:*Kyle Dippery [mailto:kyle.dipp...@uky.edu] *Sent:* Monday, March 14, 2016 8:34 AM *To:* rt-users@lists.bestpractical.com *Cc:* Seever, Kenny <kenny.see...@mgpingredients.com> *Subject:* Re: [rt-users] Unique custom fields for assets Kenny,I haven't looked at RT 4.4 yet, so perhaps it's built in there, but it wasn't in RT 4.2.What you will need to do, if it isn't there already, is create your own extension to the Asset.pm module, call it Asset_Local.pm, and add code there to check for uniqueness and auto-populate the field. The Create {} subroutine is the one you'll most likely want to override.One gotcha that I remember (I did this about a year ago) is that I needed to know the number of the custom field; I couldn't figure out how to search the $args{} array for the field by name. That being our most critical custom field, though, it made sense to create it first so it would be "CustomField-1".I'm reluctant to post my actual code, because it's crappy and I don't want to release bad code into the wild, but if you'd like to see it I can sanitize it some and share it.Cheers, Kyle On 03/11/2016 11:38 AM, Seever, Kenny wrote: Hello, I am working on evaluating using the Assets module in RT to manage our equipment, but haven’t been able to figure out if there is a way to make a field unique. All of our equipment has a 5 digit asset number (2XXXX) that is unique. I need to be able to add a field that makes sure that each number is only used once. Ideally it would auto populate with the next number when a new asset is added, but that may be asking for too much. Is there build in functionality for any of this that I’ve missed in the documentation? Thanks in advance, Kenny -- Kyle Dippery Engineering Computing Services 219 RMB 859-257-1346
-- Kyle Dippery Engineering Computing Services 219 RMB 859-257-1346
Asset_Local.pm
Description: Perl program
--------- RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Washington DC - May 23 & 24, 2016
