Forums

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

Is there no issue key (work item key) in the Atalassian Data Share jira_issue_field table?

Joanna Waligora September 9, 2025

The key e.g. PROJ-123 is the basis of human representation of jira/jsm tickets. For those needing reporting extracted via Delta Sharing, it seems like using the jira_issue_enhanced_table is the only option. That table comes in with a 5-8hr delay. Having to rely on it for the Key value renders all other approaches using 'live' tables critically deficient. Are there other field sources for this info? I see an issuekey field, but it appears to be null for all our projects. 

I'm thinking I may need to pull this via API, in combination with enhanced table queries for historical data, but that seems rather extreme for something so rudimentary, hence I think I may be missing something.

schema ref: https://support.atlassian.com/analytics/docs/data-share-schema-for-jira-family-of-products/#Tables-specific-to-Jira-Service-Management

1 answer

1 vote
Matteo Vecchiato
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.
September 9, 2025

Hi @Joanna Waligora ,

I suggest to post the question in the Analytics channel: https://community.atlassian.com/forums/Atlassian-Analytics/ct-p/analytics 

Anyway the field for issue key should be issue_key.

Kind regards 

Joanna Waligora September 9, 2025

Reposted. Thank you. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
ENTERPRISE
TAGS
AUG Leaders

Atlassian Community Events