View Issue Details

IDProjectCategoryView StatusLast Update
0021733mantisbtattachmentspublic2019-08-29 07:21
Reportervboctor Assigned Tovboctor  
Status resolvedResolutionfixed 
Product Version1.3.1 
Target Version2.23.0Fixed in Version2.23.0 
Summary0021733: Attachments should be linkable to notes in db

When a user adds a note and an attachment together they should be linked in the db. We can use heuristics to link existing attachments that are upload by users within small N seconds of time they posted a note.



related to 0021727 closedvboctor Show attachments inline with notes 
has duplicate 0022262 closedatrol Including more than two attachments to a note 
has duplicate 0023261 closedatrol Reference to a note containing a file 
related to 0009802 resolvedvboctor Support attachments associated with private notes 
related to 0023026 new 'Edit' button on bugnotes with only attachments 
related to 0024577 resolvedvboctor Deleting a note, should delete associated attachments 
related to 0026098 resolveddregad Update ERD diagram to reflect new field in bug_file table 




2016-10-01 05:57

developer   ~0054103

I strongly suggest to normalize mantis_bug_file_table into:
file table
file relations table

The relation table should be able to link a file to a bug_id, a note_id, etc

The point about heuristics should not be included in this task, as it's not relevant once the data is linked at db level.
I mean, heuristic could be used as a tool to easily link a file to a note at upload time, but not later in time.



2017-01-05 05:00

reporter   ~0054935

This is fixed, right?



2017-01-05 05:06

developer   ~0054937

Last edited: 2017-06-16 07:37

View 2 revisions

This is fixed, right?

Not fixed, there is no link in db.
Maybe you got confused by 0021727



2019-07-22 01:44

manager   ~0062404


Issue History

Date Modified Username Field Change
2016-09-30 21:30 vboctor New Issue
2016-09-30 21:30 vboctor Tag Attached: schema
2016-09-30 21:32 vboctor Relationship added related to 0009802
2016-10-01 05:57 cproensa Note Added: 0054103
2016-11-04 09:36 dregad Relationship added related to 0021727
2017-01-05 05:00 polzin Note Added: 0054935
2017-01-05 05:06 atrol Note Added: 0054937
2017-01-27 01:59 atrol Relationship added has duplicate 0022262
2017-06-16 07:35 atrol Relationship added related to 0023026
2017-06-16 07:37 atrol Note Edited: 0054937 View Revisions
2017-08-25 05:19 atrol Relationship added has duplicate 0023261
2018-07-07 16:53 atrol Relationship added related to 0024577
2019-07-22 01:30 vboctor Assigned To => vboctor
2019-07-22 01:30 vboctor Status new => assigned
2019-07-22 01:34 vboctor Severity minor => feature
2019-07-22 01:44 vboctor Note Added: 0062404
2019-08-25 16:30 vboctor Status assigned => resolved
2019-08-25 16:30 vboctor Resolution open => fixed
2019-08-25 16:30 vboctor Fixed in Version => 2.23.0
2019-08-25 16:30 vboctor Target Version => 2.23.0
2019-08-29 07:21 dregad Relationship added related to 0026098