What projects(Epics) am I working on?

Question

How can I find Epics in which I have issues (using a JQL query)?

This seems simple but JQL is SO WEAK it is NOT USABLE AT ALL except the MOST BASIC of queries. Almost anything above filtering a field is just not available. It would be fair to say that (with the current form of JQL) Jira is only slightly better than using an Excel Spreadsheet.

It is INFINITELY MORE PAINFUL that plugins can do what Jira itself can not!? Please explain why JIRA, the "J" in JQL can not include relative and useful functions in their own scripting language???

You can extend Java, Python, etc. with useful libraries, but NOT SIMPLE FUNCTIONS!!!!!!!!!!

Jehan Bhathena · Answer

Hi @Roman Bozeman

I understand you maybe a bit frustated with the limited functionality, nothing I can do to ease that unfortunately.

Since you need exact column data, try using JQL with the Jira Cloud for Excel Add-on (free) , it provides great flexibility in terms of what data you need, which is not available in the web UI.

Roman Bozeman · Answer

The problem is Jira presents itself as layered data but it is not. Each project is a table. --That's it. There are no child tasks. There are no parent-child relationships at all. It is a broken data model and therefore any substantial query is painful. And forget data mining or getting some insights. If you want that, the best thing to do is pull the data out and use it to create your own database.

Roman Bozeman · Answer

In JQL you can't even return a column. You return the whole issue row. Consequently, there is no way to get UNIQUE values in a column returned. And that is what I am looking for. What projects am I working on?