Query on date a Note was added

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
parkvillegirl
Posts: 3
Joined: 21 Sep 2020, 16:38

Query on date a Note was added

Post by parkvillegirl »

Is there a way to search / query on the date a note was added? Does Mantis save this value in its own field?
Attachments
Mantis Support Request for Note Date.PNG
Mantis Support Request for Note Date.PNG (7.64 KiB) Viewed 625 times
cas
Posts: 916
Joined: 11 Mar 2006, 16:08
Contact:

Re: Query on date a Note was added

Post by cas »

Yes, that value is stored in the bug_note_table in the field date_submitted, in addition the date of the last change to the note is stored in the same table in the field last_modified.
Having said that, i am not aware of a simple option to search on this within mantis itself. You can do this on the database but the date however is stored in unix format.
Using my query plugin would give you the option to extract the data from within Mantis.
parkvillegirl
Posts: 3
Joined: 21 Sep 2020, 16:38

Re: Query on date a Note was added

Post by parkvillegirl »

Thanks very much!
cas
Posts: 916
Joined: 11 Mar 2006, 16:08
Contact:

Re: Query on date a Note was added

Post by cas »

stumbled across this plugin, maybe useful:
https://github.com/mantisbt-plugins/Activity
parkvillegirl
Posts: 3
Joined: 21 Sep 2020, 16:38

Re: Query on date a Note was added

Post by parkvillegirl »

Thanks again!
Post Reply