How can I access jira tables?

[Alexander_Sergeevich_Denisenko]

As I understand it, with the help of an active object I can make queries to my AO tables, but I need to go to the jira tables and pull out the information I need from there, without using ComponentAccessor. 

[Nic Brough -Adaptavist-]

Your question is a bit fuzzy.  What do you mean by "go to the jira tables without using componentaccessor", for example?

[Alexander_Sergeevich_Denisenko]

for example, I need to get the data and form json, can I do this at the stage of accessing the sql database by querying the jira tables and map the result into my object. I thought to use ActiveObject but it only provides access to my own tables, not to jira tables

[Nic Brough -Adaptavist-]

You could, but you'll need to code for a data source, the data dictionary and work out all the different places things live in the database and how they are tied together by the code, and you'll not be able to get things that are calculated.

Why are you reticent to use componentAccessor?  Something that directly uses the API and is a few lines of code (possibly already available in SR docs or library) is going to be a better option than thousands of lines to do all the above.