Redmine

This plugin is development by Tech Mahindra Limited for Redmine 2.3.4.

Below triggers are implemented to customize the functionality

TRIGGER Name set_due_time :
Trigger Overview This trigger automatically sets key fields—start_date, due_date, and assigned_to_id—when a new record is inserted into the table, based on values of tracker_id and priority_id.

TRIGGER Name Update_tkt_ref_trkr_assignee:
Trigger Overview This trigger executes during an update on a record. It performs three main functions based on changes to the tracker_id, assigned_to_id, and priority_id fields. It ensures correct field values and relationships are maintained when data is modified.

TRIGGER Name Copy2IssueLog
Trigger Overview This trigger is designed to automatically create one or more copies of an issue in the issues table when certain custom fields are updated in the journal_details table.

TRIGGER Name Set_Staus_on_fb
Trigger Overview This trigger automatically updates issue status and assignment when specific conditions are met after a comment (note) is added to an issue (journals.notes). It is designed to streamline status transitions and reassignments based on tracker type and recent status history.

Please note these triggers are not actively maintained.

Open-Source Notification Provision Tech Mahindra Redmine Plugin – GPLv2 Compliance Tech Mahindra hereby notifies that its plugin for Redmine has been developed based on the open source Redmine community edition, which is licensed under the GNU General Public License version 2 (GPLv2). The Redmine community edition is an open-source project, and the use, modification, and distribution of the Redmine code, as well as any derivative works including this plugin, are subject to the terms and conditions of the GPLv2 licence. Users and recipients of the Tech Mahindra Redmine plugin are advised that any rights and obligations arising from the use of this plugin are governed by the GPLv3 licence, as applicable to the underlying Redmine source code. For further information regarding the GPLv2, please refer to https://www.gnu.org/licenses/gpl.html.

You have to add the quires into database trigger.