Table in jira database which give the data similar to issuechangefields

[devashree ma]

Earlier using restapi, i was pulling dataset with the name issuechangefields.Screenshot provided.

Now i need to pull this same data from jira schema db. But npt sure where i can find this data. Please provide information onthis.

Thanks,

Devashree

[Nic Brough -Adaptavist-]

It would be a very good idea to go back to using the REST API.

SQL is the single worst way you can get data out of Jira.  It's complex, messy, potentially slow and inefficient.  A very simple an obvious example - look at an issue.  In the UI, you visit a page and you can see the issue.  With the REST API, you can say "give me the issue" and get part or all of the issue in a machine-friendly format.  With SQL, just to get the data for a simple issue with only a couple of custom fields, you are looking at a query with 40 "join" statements, some 4 deep and many repeated.

Why do you think you "need" to do this with SQL?  What are you trying to achieve?