Nic Brough -Adaptavist- Expert

The error is about the connection to the database, but there's no information in the error about what the database is, or the versions of connectors. My initial thought is that the database driver you've got to retain compatibility with an old Confluence is not supported by the version of Java your OS upgrade has landed…

I tend to use a "child page" macro - that dynamically lists all the child pages of the current page (although given parameters, you can tell it to list other pages), down to any level you need. Once it's on the page, every time the page is rendered, the macro will list the current pages, so adding pages (and re-arranging,…

I know it says "stories", but actually it doesn't matter. It looks at all the linked issues at the story level, the issue type is irrelevant.

Ah, ok, so importing into an empty system. That's fine then, the import won't be overwriting, and project deletes will only affect the projects that you want rid of. Projects are highly independent of each other, delete only kills the project and the issues still in it, it doesn't touch anything that might be used by other…

Check the space permissions - that has a specific permission for comment, separate from view. Ack, sorry, I mis-read the question and missed the "restrictions". I have not tested it in Cloud recently, but yes, if they have comment permission in the space settings, they can still comment on a page that is restricted to…

Ok, stop for a second - what import are you using here? If it is a full site import, it will overwrite everything in your new site, everything will go. That's the import, not the delete. If your new site is "production", you will lose everything currently in it.

Select lists do not hold arbitrary strings, they hold options. To set one with a REST call, you need to feed it the ID of the option (in your case, you need the ID of the option you have named "Near zero") Go to Admin -> issues -> custom fields and find the custom field numbered 10030, go into its configuration to find the…

Yes, there are a number of tools you can add to Jira that can do this sort of thing. A starter for Scriptrunner is probably https://library.adaptavist.com/entity/create-sub-tasks-when-an-issue-is-created - I usually steal that and extend it. If you do decide to do this with SR, then remember that you'll need to create the…

Shame no-one ever reads them again ;-)

The sub-query on a Kanban board is there to define issues you do not want to see on the board because they're old, released and need no further action. An easy definition of that is "they have a fix version set", but yours might be different.

Jira Cloud does not have priority schemes, the list for the system priority is the same throughout. You could use a custom field instead of the priority, giving it different contexts (and hence lists of priorities) by project.

No, because anonymous access means "person does not log in and hence there is no password". You could create a dummy account with a password and read-only access, but that would not be in the spirit of the licence, and we all know shared accounts are insecure and shouldn't be used.

Yep, that will work, by simply shifting the problem to another system, but it'll reduce the size of the current one.

Moving an issue from one project to another is not a trivial task - all the config has to be checked and the users asked questions if there are any variations that might affect the data. In theory, you could automate all of this if two projects are identical, or you're happy to code in all the checks and amendments that…

Yes, they will, because they're now "done". I mean, they'll stay on the board, in that column, but asking "show me stuff that is not done in the sprint" won't report on them any more.

Ah, ok, much as I like Canvas, I've not used it recently. Last time I did though, there were no permissions in it beyond relying on the underlying issue permissions. Quick filters and other fields are not a function of Canvas either.

No, I'm afraid not, I get a pi symbol in my pdf. I think this one needs to go to Atlassian for deeper investigations.

Nope, it's not held in the database directly, the dates on the licences are encoded into, and extracted from, the licences. it's best not to try to do any reporting from the Jira database, it's simply not designed for it, and almost every report you might need is faster, easier, more maintainable and more helpful if you go…

Jira can be quite complicated here, as it's got several components that have different access models. Most of the access is controlled by groups though, and you can see (and amend) the relevant groups in two places. The way the groups kick in is quite simple - each application and global permission is granted to one or…

Customers only get to see the portal in front of the project. To see the project, you need to have Jira access and permission for that account to browse the project. You'll need to ask your admins about your account permissions and visibility of projects.

Not if you want them to remain attached to issues. If you yank the files out from underneath the issues, Jira will throw error messages on the issues. Jira will still work, but people won't be able to view or download the attachments. You'll also need to work out some way to record what files were removed from which issues…

Ok, that's still an automation you should be doing with a post-function or listener, not a front-end action. https://library.adaptavist.com/entity/update-the-value-of-custom-fields-through-the-script-console shows you how to work with all types of field in a function script.

There's already most of your "better overview" in Scriptrunner - have a look at the built-in scripts and look for the "script registry" There still is no single critical thing you can look at to judge the performance impacts. Each area works differently (listeners, post-functions, Behaviours, scripted fields, etc - all…

I've not written bodges like this for years, since I realised they were such an awful thing to do and needed to stop. I'm afraid I have no code to share, I've moved to doing things like this in different ways (ones that work properly and don't need maintenance) I'd question the "need" for it first. "I need to" is not a…

What do you mean by "change url"? If you want to post to a Cloud system, you need to use the url for its API.

Rather than try to start debugging this, I'm going to do the consultant thing - take a step back and ask why you are trying to do this the hard way? A Behaviour will set a field based on user input, and the field it sets will be editable by people, only filled in after people interact with an issue and won't be set if they…

Ok, that's fine, easiest thing to do here is just ignore the time fields completely and look only at the Story Points. Your velocity chart does show you estimate vs actual story points although it's not the primary intention of the chart. I'm a bit lost on "the equivalent but at a story level", because story points and…

No, that would required code change, which you can't do on Cloud. You could raise this as a feature request/improvement for Atlassian over at https://jira.atlassian.com/browse (if there isn't one already)

Jira does not have field level security. What you can do is move the edit into the workflow, so that instead of people being able to directly edit a field with an edit or by using the inline edit (remove the field from the "edit" screen), they have to click on a workflow transition. You can protect transitions with…

I've used several over the years, often for different reasons, which has lead me into using tools which are not strictly aimed at just housekeeping, but give us good information on how to do it as a by-product. Mostly it's actually migration tools that can help, as they do some analysis which can be used to inform…