JIRA API - get all projects including components

[nttinhcmus]

Hello,

I am working on JIRA Api 2 and trying to get all projects including components using this /rest/api/2/project.

When I get the single project using /rest/api/2/project/{projectIdOrKey}, I also get the components.

My question is how to get multiple projects including components.

Does anyone get the same question. Can you give me a hint.

Thank you

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

Actually, you can use workratio in JQL. See the examples.

[David Zuccaro]

Thanks, that is just what I needed.

[codelab expert]

This is not possible using JQL. The fields timespent and timeestimate require a time duration value. So you can't compare this fields.

Possible solutions:

[1] write your own plugin

[2] make excel export and compare this values in excel

[David Zuccaro]

Can't JQL create a join to the tempo data?

[David Zuccaro]

Is it not possible to do a "JOIN" between the task table and the relevent tempo table in JQL? Or do I misunderstand the back end of JIRA?

[Alex Gubar]

Hi David, 

Script Runned and 

AND issueFunction in expression("","timeoriginalestimate < timespent")