Edit date and view per month

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
cessenati
Posts: 5
Joined: 17 Nov 2020, 16:39

Edit date and view per month

Post 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
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Edit date and view per month

Post 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.
cessenati
Posts: 5
Joined: 17 Nov 2020, 16:39

Re: Edit date and view per month

Post by cessenati »

Excuse me, could you tell me where is the date location in the db?

Please.
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Edit date and view per month

Post by cas »

It is the field bug_submitted in the bug_table, be aware it is stored as unix timestamp :mrgreen:
cessenati
Posts: 5
Joined: 17 Nov 2020, 16:39

Re: Edit date and view per month

Post 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
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Edit date and view per month

Post 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
Post Reply