Comments- all of them - by a query

[Deleted user]

Hi, just want to know which table to trace all existing comments in jira database.

We are running 7.3.2. on mysql 

[Nic Brough -Adaptavist-]

I strongly recommend that you do NOT look at the database.  It is absolutely the worst possible way to do any form of reporting on Jira.

That said, the comments are in jiraaction.

[Deleted user]

Thank you.  But to verify vendor's work, we need to see all the comments in one system (not jira) migrated into jira ,  user interface cannot fulfill this request, can it ? 

we have to look at DB to compare all the comments moved over into jira with the source. 

similar what we look into attachment, like 

select A.id, A.CREATED, round (C.numbervalue, 0)  , B.filename, B.`CREATED` whenattached from jiraissue A join fileattachment B on A.id=B.issueid join customfieldvalue C on A.id=C.issue where C.customfield=10300

I just need to see what is missing in jiraaction then.  Thank you!