Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

SQL query assistance

Adam Haysley
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 10, 2024

I am trying to start create metric reports and the exports from JSM are limited to 1000 rows.  I have access to the sql server and would like to create a query that I can pull a custom field called responsible team in addition to items in the jiraissue table.  Where are the custom fields stored and what is the primary key?

1 answer

0 votes
Ahmed Arslan December 10, 2024

@Adam Haysley There is a way to increase the export limit and you don't have to go the SQL way. But you can find the schema link here for DB: https://developer.atlassian.com/server/jira/platform/database-schema/

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events