Query on date a Note was added
Moderators: Developer, Contributor
-
- Posts: 4
- Joined: 21 Sep 2020, 16:38
Query on date a Note was added
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 (7.64 KiB) Viewed 3102 times
Re: Query on date a Note was added
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.
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.
-
- Posts: 4
- Joined: 21 Sep 2020, 16:38
Re: Query on date a Note was added
Thanks very much!
Re: Query on date a Note was added
stumbled across this plugin, maybe useful:
https://github.com/mantisbt-plugins/Activity
https://github.com/mantisbt-plugins/Activity
-
- Posts: 4
- Joined: 21 Sep 2020, 16:38
Re: Query on date a Note was added
Thanks again!