Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Atlassian Jira. Admin evolution. Part 8

Part 7

JSP pages

Never use JSP pages. There are multiple disadvantages:

  • you can easily introduce security bugs
  • there is no API checks that is why it is time consuming to develop such a solution
  • you need to restart Jira after every change introduced to a JSP page, which makes development very annoying and long
  • You will not have errors in the logs if your JSP file ran with an error or had errors in syntax.
  • You need to document your solution to make sure you do not loose your solution while restoring your Jira, moving your Jira to another server, updating your Jira server.

Well, then what to use?

Jira project for lookup tables

Let's remember why we needed the database table and JSP pages in the first place. We needed it to create and manage a lookup table which stores mapping between users and managers.

And a much better way which can be used in your Jira instance is to create a Jira project for the lookup table.

For example, we can create a user_managers project with issues like this:


As you can see when I create an issue in the user_managers project, I need to provide the user and the manager. And after I create this issue you can consider that a new row has been added to a table.

The summary field is absent in the screen but ss you know the summary field is required for an issue, that is why Icreated a bit more of JS and added this JS to the announcement banner.

         $("input#summary").parent().css("display", "None");
      }, 3000);

Now everything should work.

Yes, I successfully created two issues:


So what do we have now? We have the user_managers project which stores information about users and managers and we can edit this project via UI. We will talk later how to access the data in this project. But for now we created a table and UI to manage it without a new Jira database table and JSP pages. And it was very fast and we did not use any black magic. Very nice!

We also had a requirement that only the lookup user could edit the data. And you have a very flexible Jira permission scheme to handle this requirement. Again very nice and clean solution.

But what is wrong with this solution?

The weakest link is the UI. UI is very robust. It is enough to manage the data but if your users want a more user friendly interface (lookup tables on other fields, wizards and so on), then you would need to change this solution or add a couple of plugins to this solution. We will talk about it later.

Part 9

1 comment


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

Marketplace Partner Spotlight: AppLiger

This month the spotlight is on AppLiger. We caught up with Pavel Pavlovsky, CEO and Product Manager, to learn how the company started and what fuels the team's creativity.    Atlassian:...

397 views 0 7
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