I am unable to access Jira data

dhandapani_fsy8ha

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 ')

Vero Rivas

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