How to get Teamlet,Sprint,Epic Name through sql squery ?

[Rakesh Patil]

How to get Teamlet,Sprint,Epic Name through sql squery ?

[Nic Brough -Adaptavist-]

Assuming you mean for an issue, you'll need to join jiraissue to an AO table for the sprint, look at the links table and another jiraissue row and then AO table for the epic name.  Teamlet could be anything, so we can't tell you where to look for that, unless you can explain what it is in your Jira.

Whatever you're doing though, you should not be doing it with the database, it is the worst approach to doing any form of reporting in Jira.  Could you explain what you are trying to achieve so we can tell you about better methods?