Make Name or Serial number field unique
Moderator: crythias
Make Name or Serial number field unique
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?
Or is there a way to make a field, in this case 'serial number' unique?
-
- 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
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.
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
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
Re: Make Name or Serial number field unique
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.
Re: Make Name or Serial number field unique
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.
-
- 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
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.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.
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
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
Re: Make Name or Serial number field unique
it is supported for CI Names since 3.1.7.
http://www.otrs.com/en/open-source/comm ... -itsm-317/
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: Make Name or Serial number field unique
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 wrote:it is supported for CI Names since 3.1.7.
http://www.otrs.com/en/open-source/comm ... -itsm-317/
Re: Make Name or Serial number field unique
you can upgrade from 3.1.x to 3.2.y directly
Please always follow the UPGRADING file in the new version
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
Your link is not accessible now. How to make CI Names unique?jojo wrote:it is supported for CI Names since 3.1.7.
http://www.otrs.com/en/open-source/comm ... -itsm-317/
-
- 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
I Found it, we can configure this on SysConfig, SubGroup Core::ITSMConfigItem. Thanks for OTRS for this feature.denbagusjkt wrote:Your link is not accessible now. How to make CI Names unique?jojo wrote:it is supported for CI Names since 3.1.7.
http://www.otrs.com/en/open-source/comm ... -itsm-317/