Adding additional fields to bugnotes.

[xvxNe0xvx]

Hi there, I would like to add some additional fields to the bugnotes category. I have been customizing bugtracker to work as a job tracking and I am using "bugnotes" as a "report" field for our engineers. I need to be able to add fields such as "job start time", "job end time", "date" to each note. Just having them as a global field isn't good enough as each note (report) has its own start/end time (have been using this as a work around in the mean time).

I know php but this will require me to ether edit the sql database to add the fields or write a function to add these fields to the existing note then pull them out when needed (so the "note" string in the database will actually be something like 10 chars for start, 10 chars for end, 10 for date, then the rest for the actual note... and will look like this "10:30am***12:30pm***1/5/10****here is the note"). Ether of those ways are going to require a lot of work so was wondering if anyone has any better ideas or if there’s something I’m missing?

Thanks a lot.

[atrol]

Have a look at this plugin
http://www.mantisbt.org/bugs/view.php?id=11912
Maybe a good starting point for you