JQL query for list of components?

[Dustin]

We are using a Jira Project for our client and components as our individual projects for that client and would like to have a list of the open components (i.e. projects) which would consist of any component that has active/non-resolved issues associated with it. We'd display this on a dashboard using a filter component gadget. We do have Script Runner as well if it could only be done using that.

[Nic Brough -Adaptavist-]

JQL is not SQL, it's for finding issues. It will not list components, because they're not issues.

Best I can do is tell you to create and save a filter for "project = x and resolution is empty" to get the list of active issues, then add a "filter statistics" gadget to the dashboard.  Tell it to use the saved filter, and select "component".

You should then get a list of active components, with a representation of how many issues are open against them.