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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Adding new column into database

Hello,

 

I would like to add a new column (a boolean) into the jiraaction table. Is there any problem with doing so?

I am trying to mark certain comments ahead of extraction as relevant and giving them a flag seems to be the only way... Atleast I haven't found any addons that can do this.

 

I know the general opinion is to not touch the databases directly, but I just want to know, if adding addiotional data can break something.

 

Best regards

1 answer

0 votes

Do not do this.

You will not be able to upgrade unless you change the code such that it knows how to account for your column, and you will need to make significant changes to the core code in order to use the column.  As you go to investigate that, you'll find the code to do it is nowhere near as simple as you are guessing it might be.  Any of those changes render you totally unsupported (and unable to move to Cloud or DC when server goes away in 2024)

Do it properly, write an app that stores and uses the data in active objects.

Well, I'm not sure my boss will even want to change to cloud like... EVER. So atm its not a concern of mine. Why and how would I have to adjust the code though?

 

Can't i just use a standard sql command to add a column to the table and not bother about it anywhere in the software itself?

No you absolutely can not "just add a column", you will break it completely. 

Please also have a look at the rest of my answer, it's not just breaking the move to Cloud or DC you need to worry about.

I guess some iteration errors might occure when a table is suddenly longer than it is supposed to, but what ever, it would have been way too easy anyways...

Just hypotethically, what about ADDING a completely new table? I could just do it on a separate database, but it would be a waste of space, to have to copy the jiraactions table on a regular basis.

 

 

To your suggestion regarding writing an app:

I'm having trouble figuring out, how to create my own applications. The only thing I find is the Atlassian SDK:

https://developer.atlassian.com/server/framework/atlassian-sdk/configuring-the-plugin-descriptor/

It seems to be made for Jira, is it also the way to go, when creating Service Desk applications?

That's only one error that can occur, there's loads of others.

Yes, it is safer to add a new table that has nothing to do with Jira, but you are now making a rod for your own back - you'll have to code a complete access layer for it, embedded in Jira's core, or including all the access layers in an app, not just piggybacking Jira's layer.

You will still render your system unsupported, non upgradable, and non migratable.

For getting started on writing an app, I usually point our new coders at https://developer.atlassian.com/server/framework/atlassian-sdk/create-a-helloworld-plugin-project/

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

Why upgrade to Jira Service Management Premium?

We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan.  &nb...

196 views 1 6
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