Need help to get only count of issues using jira plugin for excel (jira.jql)

[UdayKiran]

Need help to get only count using jira plugin for excel (jira.jql).

I've using jira.jql(excel plugin function) to get the list of issues.

Is it possible to get only the count of issues returned by the JQL instead of the list?

[Geethanjali Katagani]

You can use filter search, then export the result to Excel.

for example, filter query :

project= "Example " AND issuetype=Story AND status = "To Do"

You can add the desired conditions to the query and get the result.

[UdayKiran]

thanks!

There is a Jira plugin for excel and through that we can query Jira directly from excel.

So looking to get only count of issues that JQL returns. :)

[Geethanjali Katagani]

Great!

[Geethanjali Katagani]

Hi Uday,

You can create the dashboard and use the issue statistics gadget to know the issue count.

As shown below.

Regards,

Geethanjali

[UdayKiran]

Hi Geethanjali,

I'm looking at a way to get the number of issues that a JQL returns in excel