If the manager has been deactivated we need to change this manager to the supermanager user. How to do it? Easy! We will create a trigger for the cwd_user table. And if a user is deactivated then we will update the customfieldvalue.
First we will create a pl sql procedure:
CREATE OR REPLACE FUNCTION public.changeusermanager()
IF NEW.active <> OLD.active and NEW.active = 0 THEN
update customfieldvalue set stringvalue = 'supermanager' where customfield = 10300 and stringvalue = NEW.user_name;
And now we can create a trigger:
create trigger changemanager before
public.cwd_user for each row execute procedure public.changeusermanager();
Let's check how it works. Open the User Management Jira settings and deactive the manager1 user:
Click the Update button and let's open one of our created issues:
We created a solution for our approval process and ready to inform our manager that the task has been completed!
In the next articles I will explain why these techniques are low quality and, what is most important, how to make a better quality solutions.
Alexey Matveev _Appfire_Community Leader
Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events