Configuration to disallow dup part numbers? Even with diff cage code?
Feb 06, 2012
02:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Feb 06, 2012
02:45 PM
Configuration to disallow dup part numbers? Even with diff cage code?
Does anyone know if there is a configuration setting that can be made to disallow duplicate part numbers to be created, regardless of the cage code? So if part 123a456 has been created, it cannot be created again even with a diff cage.
I know I can setup a listener on create, but if there was a simple OOTB setting that would great.
Labels:
- Labels:
-
Other
3 REPLIES 3
Feb 06, 2012
03:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Feb 06, 2012
03:14 PM
Database level unique constraint of both columns would do the trick. Keep in mind this is how system currently enforces number uniqueness.
Sent from my Verizon Wireless BlackBerry
Sent from my Verizon Wireless BlackBerry
Feb 07, 2012
02:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Feb 07, 2012
02:39 PM
this is a configuration to the database index. But you have to clean the system first. If you want the uniquenss accross the entire Windchill system, you have to remove the orgid column from the index.
Feb 08, 2012
03:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Feb 08, 2012
03:53 PM
Thanks guys. I was given some info, today, that it can't be locked down to every part that is created, so listener it is...
