Relationship Graph

View IssueDependency GraphShow Summary
Relationship Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0021733mantisbtattachmentspublic2016-09-30 21:302024-09-16 06:39
Reportervboctor Assigned Tovboctor  
PrioritynormalSeverityfeatureReproducibilityN/A
Status closedResolutionfixed 
Product Version1.3.1 
Target Version2.23.0Fixed in Version2.23.0 
Summary0021733: Attachments should be linkable to notes in db
Description

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.

Tagsschema

Relationships

Relationship GraphDependency Graph
related to 0021727 closedvboctor Show attachments inline with notes 
parent of 0009802 closedvboctor Support attachments associated with private notes 
parent of 0024577 closedvboctor Deleting a note, should delete associated attachments 
parent of 0025935 closedvboctor Warning for users when making public notes with attachments private 
parent of 0022817 closedvboctor "private bugnotes" as default setting prevents uploading further attachments 
parent of 0025960 closedvboctor Add files information to EVENT_BUGNOTE_ADD event 
has duplicate 0022262 closedatrol Including more than two attachments to a note 
has duplicate 0023026 closeddregad 'Edit' button on bugnotes with only attachments 
has duplicate 0023261 closedatrol Reference to a note containing a file 
related to 0026098 closeddregad Update ERD diagram to reflect new field in bug_file table 
related to 0026489 closeddregad Note gets separated from attachments 
related to 0026835 closedatrol Database Server error while adding file to project 
related to 0034597 feedback Problem with order in atached files when migrate Version From 2.14.0 to Version 2.26.1 

Activities

cproensa

cproensa

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.
polzin

polzin

2017-01-05 05:00

reporter   ~0054935

This is fixed, right?
atrol

atrol

2017-01-05 05:06

developer   ~0054937

Last edited: 2017-06-16 07:37

This is fixed, right?

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

vboctor

2019-07-22 01:44

manager   ~0062404

PR: https://github.com/mantisbt/mantisbt/pull/1529