Page 1 of 1

Edit date and view per month

Posted: 15 Jan 2021, 16:41
by cessenati
Hello!

1.- I have a question, is there a way to change the date of an incident?

2.- Is there a way to see the summary of incidents for months? :D

Re: Edit date and view per month

Posted: 16 Jan 2021, 10:22
by cas
1. you can duplicate the ticket or add a customfield to track that seperately if it happens a lot.
- alternatively change directly in the DB, not recommended but can be done.
2. Not out of the box, best to use a plugin for that.

Re: Edit date and view per month

Posted: 18 Jan 2021, 16:30
by cessenati
Excuse me, could you tell me where is the date location in the db?

Please.

Re: Edit date and view per month

Posted: 18 Jan 2021, 17:13
by cas
It is the field bug_submitted in the bug_table, be aware it is stored as unix timestamp :mrgreen:

Re: Edit date and view per month

Posted: 18 Jan 2021, 21:20
by cessenati
I only have such tables: :cry:
mtsg_api_token_mantis
mtsg_bugnote_mantis
mtsg_bugnote_text_mantis
mtsg_bug_file_mantis
mtsg_bug_history_mantis
mtsg_bug_mantis
mtsg_bug_monitor_mantis
mtsg_bug_relationship_mantis
mtsg_bug_revision_mantis
mtsg_bug_tag_mantis
amtsg_bug_text_mantis
mtsg_category_mantis
mtsg_config_mantis
mtsg_custom_field_mantis
mtsg_custom_field_project_mantis
mtsg_custom_field_string_mantis
mtsg_email_mantis
mtsg_filters_mantis
mtsg_news_mantis
mtsg_plugin_mantis
mtsg_project_file_mantis
amtsg_project_hierarchy_mantis
mtsg_project_mantis
mtsg_project_user_list_mantis
mtsg_project_version_mantis
mtsg_sponsorship_mantis
mtsg_tag_mantis
mtsg_tokens_mantis
mtsg_user_mantis
mtsg_user_pref_mantis
mtsg_user_print_pref_mantis
mtsg_user_profile_mantis

Re: Edit date and view per month

Posted: 19 Jan 2021, 09:35
by cas
Looking @ the naming convention, I would put my money on:
mtsg_bug_mantis
Check this table and field "date_submitted" will most likely be there