View Issue Details

IDProjectCategoryView StatusLast Update
0024228mantisbtcustom fieldspublic2019-02-10 11:19
ReporterfmanAssigned Toatrol 
PrioritynormalSeverityminorReproducibilityalways
Status feedbackResolutionreopened 
Product Version2.12.0 
Target VersionFixed in Version 
Summary0024228: mantis_custom_field_table - add unique index on name
Description

IMHO creation of two custom fields with the same name has to be blocked not only at application level but also at DB level, that's why adding a unique index on the name could be a good thing.

regards

TagsNo tags attached.

Relationships

has duplicate 0025142 closedatrol nice to have - custom_field table - column name has not unique constraint 

Activities

atrol

atrol

2019-01-05 10:57

developer   ~0061151

You can use the same name for fields with different definitions in different projects.
For example have a field Reseller of type enumeration with different reseller lists in different projects.

Do you agree that we can set your issue to resolved?

atrol

atrol

2019-01-30 15:51

developer   ~0061336

fman,

You did not provide any feedback; I am therefore resolving this issue as "no change required".

Feel free to reopen the issue at a later time and provide the requested information.

fman

fman

2019-02-10 11:19

reporter   ~0061476

I apologize for the missing feedback.
IMHO if you need to have the same concept with different domains on different projects is not ok using the same name.
If custom field management is done by a small group of people you can manage the fact that system blocks you.

One annoyance: the custom field api that allow you to get Custom Field BY NAME is going to return multiple records, then making some kind of implementation difficult.

thanks again for your product

Issue History

Date Modified Username Field Change
2018-04-05 06:04 fman New Issue
2019-01-05 10:27 atrol Relationship added has duplicate 0025142
2019-01-05 10:57 atrol Status new => feedback
2019-01-05 10:57 atrol Note Added: 0061151
2019-01-30 15:51 atrol Assigned To => atrol
2019-01-30 15:51 atrol Status feedback => resolved
2019-01-30 15:51 atrol Resolution open => no change required
2019-01-30 15:51 atrol Note Added: 0061336
2019-02-10 08:32 atrol Status resolved => closed
2019-02-10 11:19 fman Status closed => feedback
2019-02-10 11:19 fman Resolution no change required => reopened
2019-02-10 11:19 fman Note Added: 0061476