Page 1 of 1

Query on date a Note was added

Posted: 21 Sep 2020, 17:57
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?

Re: Query on date a Note was added

Posted: 22 Sep 2020, 08:49
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.

Re: Query on date a Note was added

Posted: 23 Sep 2020, 02:48
by parkvillegirl
Thanks very much!

Re: Query on date a Note was added

Posted: 24 Sep 2020, 08:08
by cas
stumbled across this plugin, maybe useful:
https://github.com/mantisbt-plugins/Activity

Re: Query on date a Note was added

Posted: 24 Sep 2020, 21:53
by parkvillegirl
Thanks again!