Where are comments/text contributions stored in the local data store of Jira/Confluence Data Center?

[Gabriel Heuberger]

I would like to ask if you know where comments/text contributions are stored in the local data store of Jira/Confluence Data Center? What are the file formats?

[Nic Brough -Adaptavist-]

There is no "file repository" for most of the data, it's all in the database.  Only the attachments are stored as files on a disk (and they are literally copies of the file you upload bit-for-bit identical)

If you want to "access" the data in the database, you could use a database tool to read it, but you won't like the format; it's not designed for any form of reporting, and you'll find yourself building torturous non-performant queries to get even the most simple bits of data out and having to translate a lot of it to make it even vaguely human readable.

You should be using the REST API or the UI to read the stuff you've stored in the applications.

What are you actually trying to achieve here?  (Not the "how", but what do people get from your reading of the issues/pages?)

[Fabio Racobaldo _Herzum_]

Hi @Gabriel Heuberger ,

welcome to the Atlassian community!

Comments are stored at DB level.

Hope this helps,

Fabio

[Gabriel Heuberger]

Thank you for your quick reply. How can I access these in the file repository? Please excuse my question, I am unfortunately not that versed in database topics.

[Fabio Racobaldo _Herzum_]

You can access DB on a cloud instance. You can retrieve data through REST API https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/

Ciao,

Fabio

[Gabriel Heuberger]

Does this only affect Jira Cloud or also Jira Data Center? I am looking for a solution for the Data Center version

[Nic Brough -Adaptavist-]

The REST APIs are different between Cloud and Server/DC, but they are somewhat similar in the way they work (the call "show me an issue from Jira" is almost identical in both construction and response from both types of system)

See https://developer.atlassian.com/server/jira/platform/rest-apis/

[Gabriel Heuberger]

Thank you very much for the information and your clarifications