Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

how to include transaction periods for all tables in jira

pragathi inaganti May 27, 2021

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

2 answers

0 votes
Daniel Ebers
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 4, 2021

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

0 votes
Vero Rivas
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 27, 2021

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

pragathi inaganti May 27, 2021

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events