I access the jira database using sql script and i update the database. But i can not see the database changes in the jira user interface. I want to change the jira UI for those direct changes in database. How i can do it? Thanks.
If you install script runner plugin, you could run the clear jira caches script: https://studio.plugins.atlassian.com/wiki/display/GRV/Built-In+Scripts#Built-InScripts-ClearJIRAorGroovyCaches
If restarting makes it work, then probably this script will make it work too, without having to restart.
Having said that, I agree with the other comments telling you to use the API.
Most of the APIs you're looking for can be found in example code, eg the Copy Project script in the above plugin.
You should never amend a Jira database while it is running (with some minor and very small exceptions). If it's offline, you can do more, but depending on the data you've changed, you almost certainly need to re-index afterwards. I suppose it's too late to tell you that you should also get a proven backup of your database before doing this...
Anyway, what *exactly* did you do to your data? Can you easily undo the changes?
I hope you have a backup? You may need it.
As @nic said, it is always better to go via the APIs. But in some cases, you will end up doing it in DB. Make sure you know what you are doing and do it when JIRA is offline. You can't escape from restarting JIRA (some of them works even without restart but I won't advise it in production!).
Like I said, there are possibilities that you will need to do a SQL script. In that case, you need to do a Jira backup, and a DB backup just in case, stop the jira service, do the changes, verify all is correct and restart the Jira service. Do some tests to verify all is good and go on. If something goes bad, you can restore the Jira or the DB and pray everything is fine ;)
Er, the API does support changes to schemes. If it didn't, then the UI wouldn't allow you to change it - think of the UI as an Atlassian written front-end to data-structure. It *must* use the API to make all the changes, so the API must support what you're doing.
And to repeat myself again, you must not update the database while Jira is running. And be very careful even when it's not.
May we ask what you're actually trying to do?
Well, that's not an answer to the question I asked, so I can't go into any specific detail, but the general answer is:
You said that if we can access Schemes in jira UI also we can access all them through API. Then can you help me to get those methods to throw API.
2.Issue Type Screen Scheme
3.Field Configuration Scheme
These are the schemes which i want to find out methods to access throe API
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hi Community! My name is Amir and I’m on the Jira Service Desk product marketing team at Atlassian. Our team would love to understand how you’re leveraging our ecosystem for Jira Service Desk. Wha...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs