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
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

I am unable to access Jira data

dhandapani
dhandapani
Contributor
December 9, 2021

I am accessing data from SQL server, Using LinkedSErver we re accessing data from JIra.

We can select Project,issue details etc tables. But we are unable to access AO tables. Anyone can help to resolve this?

using below query unable to access the AO tables, the same is working for other tables.
select *,getdate() from openquery(JIRA, 'SELECT * FROM public.AO_00B950_AOFIELD ')

Answer
Watch
Like Vero Rivas likes this
284 views

1 answer

0 votes
Vero Rivas
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.
Get recognized
January 24, 2022

Hi @dhandapani 

   Look at this posts, maybe can help you

   https://confluence.atlassian.com/jirakb/how-to-identify-active-objects-ao-tables-in-jira-application-database-830279481.html

   https://community.atlassian.com/t5/Jira-questions/Access-to-ActiveObjects-tables-via-JDBC/qaq-p/144095

   https://community.atlassian.com/t5/Jira-questions/How-can-I-access-jira-tables/qaq-p/1405045

Cheers

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Upcoming Jira Events