how to include transaction periods for all tables in jira

Question

i don't know how to include transaction periods for all tables in jira. From where I need to start to close this issue

Daniel Ebers · Answer

Hi @pragathi inaganti

I think it is kind of unclear yet to Community members what you are looking at. With some likeliness you are trying to access Jira's database for reporting purposes and/or you are trying in first step how data is organized.

In many posts here in Community one can read that reporting off Jira's database will not bring the desired output - the schema is hard to understand and not made for reporting.

Instead, accessing the REST API could be an alternative:
https://developer.atlassian.com/server/jira/platform/rest-apis/

To be honest, I am not familiar with the term "transaction periods" so it could be that this would not help you either.

Cheers,
Daniel

pragathi inaganti · Answer

Hi @Vero Rivas . Thank you for your  response. But i have existing report, now i need to include transaction periods for all tables.

Can you please help me in that.

Vero Rivas · Answer

Hi @pragathi inaganti

I do not know if it is possible, but I give you this link of the DB schema it can help you

https://developer.atlassian.com/server/jira/platform/database-schema/

Cheers