Make Name or Serial number field unique

Moderator: crythias

Post Reply
Sophy978
Znuny newbie
Posts: 83
Joined: 06 Jul 2012, 22:01
Znuny Version: 3.1.5
Real Name: Sophy

Make Name or Serial number field unique

Post by Sophy978 »

Hello, is there a way to make the Name field in config item unique?

Or is there a way to make a field, in this case 'serial number' unique?
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Make Name or Serial number field unique

Post by crythias »

Sophy978, I'm only responding in case nobody else will.
In order for this to occur, it needs best to be handled by validation after submit. I have some ideas about that, but I don't have sufficient time to express them completely.

When I get a few hours together, I'll post something with respect to dependent fields and validation that will address some outstanding questions that aren't sufficiently answered (even/especially by me) for those who are asking.

Your request may involve a bit of programming in the appropriate Kernel/Module that applies to the screen you're using to submit name or Serial number.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Sophy978
Znuny newbie
Posts: 83
Joined: 06 Jul 2012, 22:01
Znuny Version: 3.1.5
Real Name: Sophy

Re: Make Name or Serial number field unique

Post by Sophy978 »

Crythias, sounds good. We'll use the field as is for now. When you do post a solution, I'll implement that as well. Thanks.
Sophy978
Znuny newbie
Posts: 83
Joined: 06 Jul 2012, 22:01
Znuny Version: 3.1.5
Real Name: Sophy

Re: Make Name or Serial number field unique

Post by Sophy978 »

Hello Crythias - any chance you can post the solution for making a field unique? Now we are running into issues where we have the same serial number entered. Thanks.
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Make Name or Serial number field unique

Post by crythias »

Sophy978 wrote:Hello Crythias - any chance you can post the solution for making a field unique? Now we are running into issues where we have the same serial number entered. Thanks.
Not retroactively. If you set a unique index on the field, it would error on try to store, but retroactively you'll need to remove the dupes.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Make Name or Serial number field unique

Post by jojo »

it is supported for CI Names since 3.1.7.
http://www.otrs.com/en/open-source/comm ... -itsm-317/
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Sophy978
Znuny newbie
Posts: 83
Joined: 06 Jul 2012, 22:01
Znuny Version: 3.1.5
Real Name: Sophy

Re: Make Name or Serial number field unique

Post by Sophy978 »

jojo wrote:it is supported for CI Names since 3.1.7.
http://www.otrs.com/en/open-source/comm ... -itsm-317/
Awesome, thanks for pointing this out. We are currently at 3.1.5. We haven't done and upgrade yet but are planning to. Are the upgrades incremental or can we just upgrade to 3.2?
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Make Name or Serial number field unique

Post by jojo »

you can upgrade from 3.1.x to 3.2.y directly

Please always follow the UPGRADING file in the new version
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
denbagusjkt
Znuny newbie
Posts: 23
Joined: 07 Jun 2012, 09:20
Znuny Version: 3.1.5
Real Name: denbagus
Company: indolabsoft

Re: Make Name or Serial number field unique

Post by denbagusjkt »

jojo wrote:it is supported for CI Names since 3.1.7.
http://www.otrs.com/en/open-source/comm ... -itsm-317/
Your link is not accessible now. How to make CI Names unique?
denbagusjkt
Znuny newbie
Posts: 23
Joined: 07 Jun 2012, 09:20
Znuny Version: 3.1.5
Real Name: denbagus
Company: indolabsoft

Re: Make Name or Serial number field unique

Post by denbagusjkt »

denbagusjkt wrote:
jojo wrote:it is supported for CI Names since 3.1.7.
http://www.otrs.com/en/open-source/comm ... -itsm-317/
Your link is not accessible now. How to make CI Names unique?
I Found it, we can configure this on SysConfig, SubGroup Core::ITSMConfigItem. Thanks for OTRS for this feature.
Post Reply