Nic Brough -Adaptavist- Expert

Yes, your row numbers may be fine in one very specific place, but they're useless everywhere else, because you're going to get different numbers. Similarly, they're going to be obsolete as soon as you extract them, because things change.

mmm, I have to take issue with "The current database structure is not a challenge for the average data analyst." - I've shown the Jira database to some well-above average data analysts and they've all agreed - don't use it. It is an expert-level data analyst I'm quoting when I say "The Jira database is not intended for…

Ahh, good! i was hoping that was the problem! My usual trick is to forget that I, as a normal user, can't see everything another normal user (like the one running the Confluence service) can see.

Have you looked at the apps or Atlassian access?

I'm afraid all the feature requests for "multiple sorts" have been closed with not just "won't do", but "can't do". You can only use ranking if the list you are working with is ordered by ranking. Because the rank is unique, and priority is not, ordering by priority stops you from ranking. It's not a function of the UI or…

Your active spring board will not contain issues completed in previous sprints, you don't need to do anything to make that happen. Your main question can be answered without looking at dates, try adding this to a copy of your board filter: and ( Status not in ( ) and sprint not in openSprints() )

Yep, that makes sense. Your Confluence is not connected to an MS-SQL server, it is using the local embedded database. The database driver is showing as "h2", with a username of "sa", which, by default, does not need a password. name="hibernate.connection.driver_class">org.h2.Driver</property> <property…

Welcome to the Atlassian Community! That is "the billing link". You need to follow it through to make a payment.

So you do have a username set in the file, as I would expect from a JDBC connection. Could you show us the rest of the file? Please do obscure anything sensitive, we just need to see the raw XML and that any particular tag pair contains some data. Jira won't work without a dbconfig.xml file in the home (data) directory,…

If you are using a JDBC connection, then the username, password, and connection string are in <confluence home>/confluence.cfg.xml If you haven't got them in there, then you are not using a JDBC connection. Could you be looking in a sample or copy of the confluence.cfg.xml?

Welcome to the Atlassian Community! Reconfigure the board the burndown chart belongs to. Put "Test ok" in the very last (rightmost) column on the board. Then make sure "done" is in a column before "test ok"

Welcome to the Atlassian Community! I do not understand the question. Could you explain what "lango as a user" means? And "adding it to a page"?

Ah, ok, so your "row number" is a rank. That's fine, but you now have the problem that it will be overriding all the ranking in Jira, making the rank in Jira pointless, as well as only being valid for one backlog at a time.

They almost certainly are wrong. But you've never explained exactly what the row number means to you. Where do you think you want to see this row number? Why would it not change if you changed the sort order of the issues, or looked at a different report? Row 123 in the issue navigator is rarely going to be row 123 in the…

Use a reporting tool that understands Jira data for you. EazyBI for example, as per the answer from @Janis Plume (eazyBI) or have a look in the Atlassian marketplace for other options. Or look at Atlassian's data lake option.

You will need an SSO app, or Atlassian Access to do this on Cloud.

Welcome to the Atlassian Community! You will need to make a REST call to get the sprint(s) start and end dates, plus the estimation statistic in use, then a second REST call to search for all the issues you want to calculate the velocity from, including the data for their estimates, sprints, and changes of status from…

I'm not refraining from answering anything. I am trying to explain why SQL is the worst possible way you can report off Jira. The Jira database is not useful for reporting off. It's complex, so most people don't understand it well enough to be able to begin to build useful reporting from it, and even when they do, most of…

What are you expecting from a "REST endpoint for a screen"?

See the answer I gave May 19, 2021

So your Tableau reports are now wrong?

So you now understand that SQL is the worst possible way to report on a Jira system?

Welcome to the Atlassian Community! This means that the "bug" issue type is not a sub-task issue type, it is base-level. You need to select a sub-task issue type as the target type.

Nope, there are plenty of other use cases, but the basic logic is still that if you want any form of rating or voting to be useful and not abused, you need to be able to count votes by some unique identifier. This is something which you can not get from an anonymous source.

Welcome to the Atlassian Community! It is complete nonsense to have sub-tasks in different sprints to the sprint their "parent" issue is in. A sub-task is a fragment of an issue, not a sprint item itself. Your subtasks will only ever be considered to be part of the sprint the Story is in.

Welcome to the Atlassian Community! Jira Work Management (business) team-managed projects do not support sprints. You need to be using a Jira Software project.

There's no way to do this without making like/react/vote utterly useless. Imagine this really simple case: * Alice looks at a page, logs in, and clicks like.* You record Alice liked the page * Bob looks at a page, and clicks like.* You don't know who Bob is because they are anonymous, but heck, yes, record that Anonymous…

Welcome to the Atlassian Community! In most cases, it has to contain the database connection details, for Confluence to work. The exceptions are: * The Confluence has been configured to use a local embedded database (h2, not suitable for a production server). You may find blank entries for username/password, or even…

I agree with you, it disappoints me to think vendors are not even looking at the process. It does not make a lot of sense to me for a vendor to be thinking "we'll start our compliance journey when the platform we build for gets their certification". But I understand that we can be a bit stuck. There's no point applying…

I'm afraid it is absolutely true. Please re-read the third line in my answer there, but I should have emphasised the last words as "Jira data". BI analytics tools are great, when they are pointed at databases that are built for reporting, or have well-defined data dictionaries written by people who thoroughly understand…