View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0003792||mantisbt||custom fields||public||2004-04-29 14:42||2013-12-01 22:05|
|Summary||0003792: Additional Custom-Field-Type "counter"|
Mantis uses a ID field for all projects. I recommend a new custom-field-type with a similar meaning, but limited to a project. A normal text-field does not ensure ID-uniqueness.
Why I need this?
|Tags||No tags attached.|
As the name says: ID is an (unique) identifier. I think it's better to explain your customer that you are working on different projects than having dublicate (custom) ID's?
Thats true, but it is hard, to tell a customer that different projects share the ID workspace, especially if the customer does not trust your methods. They may think, you are hiding information (bugs with IDs of other projects) for them.
Its similar, if you dont ship a version 0.19 of mantis, but a version 0.20. So everyone asks, why 0.19 is missing (maybe its too buggy for realize). It always leaves a bad taste.
by counter are you looking for say, select MAX(value) where customfieldid = 10 for example, or a unique identifier.
The first version would be fairly easy to implement as the value could be looked up at runtime. However, using this method, and as mantis doesn't use transactions, it would always be possible that you could somehow duplicate an id if it was entered at the same time.
The last one.
Counter should be unique but deletion is allowed and leaves a hole. The deleted id should not be used anymore. Its the same like the id for reports (autoincrement).
|2004-04-29 14:42||RJelinek||New Issue|
|2004-04-30 04:16||djockheck||Note Added: 0005452|
|2004-04-30 04:56||RJelinek||Note Added: 0005455|
|2004-08-14 15:53||grangeway||Note Added: 0006989|
|2004-08-15 08:37||RJelinek||Note Added: 0006991|
||Note Added: 0038782|