What table in the database contains fixVersion information?

[Justin Corcoran]

I imported a bunch of issues into a project, and created a Rapid board for that project. For some reason, the issues don't appear on the board unless I remove the default sub-filter fixVersion in unreleasedVersions() OR fixVersion is EMPTY

If I do remove that filter, the issues appear, but then they don't disappear when I "release" them from the Done column (which makes sense). I'm guessing that somehow in the import, the fixversion got set to some value. No value appears when I search for issues, and when I run the JQL project = maintenance and )fixVersion in unreleasedVersions() OR fixVersion is EMPTY) no issues appear. I also tried running the inverse of that: project = maintenance and (fixVersion not in unreleasedVersions() OR fixVersion is not EMPTY) and I still get no issues returned.

I'd like to look in the database and see if anything is set in the fixVersion, but I can't seem to find it. Any ideas?

[Adam Saint-Prix · Accepted solution]

http://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-FindFixedForversionsforanissue

[Kannan Sundararaj]

The link is missing . Please update the latest link in which we can find this information

[Petr Musil]

I found https://confluence.atlassian.com/display/JIRA041/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-FindFixedForversionsforanissue

there are three tables, where are used Fixversions:

1) jiraissue

2) projectversion

3) nodeassociation

[Kannan Sundararaj]

The link is missing the page. Please update the latest link in which we can find this information

[Adam Saint-Prix]

http://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-FindFixedForversionsforanissue