Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Atlassian Jira. Admin evolution. Part 1

Hello!

In this series of articles I will show you how the same task can be solved in many different ways in Atlassian Jira Server/Data Center.

I will solve this task with different skillsets and understanding of Atlassian Jira. I will start with the lowest quality solution and move to higher quality solutions.

After reading this series of articles you will be able to understand what is the quality of solutions you have in your Atlassian Jira.

I will not produce the complete code of the task for each solution. My goal is to show techniques which can be used to configure Atlassian Jira and let you understand the quality of each of the techniques.

Task

We need to create an Approval process for our company. It will be a very simple process but enough to create all types of solutions.

Here is the workflow for our issues:

Screenshot 2020-06-10 at 11.17.42.png

Here is the business process:

  • during creation of an issue the manager of the reporter should be set automatically as the approver of the issue in the Approver field. The Approver field should not be available for editing.
  • the manager of a user must be taken from a lookup table. The lookup table should be managed by a lookup user who does not have admin access to Jira or access to the database.
  • only the user in the Approver field can transition an issue from the "On Approval" status to the "Ready For Work" status.
  • if the user in the Approver field has left our company (we deactivated this user), then the Approver field should be set with the head manager in our company.

The lowest quality solution possible

How would I approach this task if I knew nothing about Atlassian Jira?

DB Table

If we want to set the manager of the reporter as the approver of an issue automatically, then we need a lookup table where we would find information about the manager for each user. How to have this lookup table? Of course, we can create a table in our Jira database. And I will create one. I use Postgres for my Jira instance that is why I will take my favourite GUI for managing Postgres database and create a table:

Screenshot 2020-06-07 at 19.56.11.png

I provided user_managers as the name of the table and added two columns: user and manager.

Now we need to let our lookup user to edit this table. We can not grant access to the database to the lookup user. We need somehow to create a UI in Jira to let the lookup user edit this table.

How to do that?

Part 2

1 comment

Mohammed Amine Community Leader Jun 04, 2021

Amazing article to read

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

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 ...

605 views 7 23
Read article

Community Events

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

Events near you