JQL to retrieve how many tickets have been assigned per day

[Pourna Radha-Burhoo]

Hello,

I am looking for JQL to get the number of ticket which have assigned at end of day.

Thanks,

Swarna

[Taha El Majidi · Accepted solution]

Hi @Pourna Radha-Burhoo ,

I don't know if I understood your requirement. But if you need issues assigned during the day, I think this might help : 

assignee WAS EMPTY BEFORE startOfDay() AND assignee is not EMPTY

[Bill Sheboy]

Hi @Pourna Radha-Burhoo 

First thing: Jira queries with JQL return issues, not issue counts.  You may get the count by querying the issues and looking at the results.

Next, would you please clarify what you mean?  That will help the community to offer suggestions.  For example, do you mean:

1. What are all of the issues assigned at the end of today, regardless of other criteria?
2. What are all of the issues assigned during today, regardless of other criteria?
3. What are all of the issues assigned during today, and which were not assigned earlier?
4. One of the above, but only for issues which are not completed (or which were completed today)?
5. One of the above, but for a specific date other than today?
6. Or something else?

JQL operators to help you answer such questions are the CHANGED and WAS operators, which you may learn more about here: https://support.atlassian.com/jira-software-cloud/docs/jql-operators/

You can also learn how to answer such questions with this free training from Atlassian: https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

Kind regards,
Bill

[Ste Wright]

Hi @Pourna Radha-Burhoo 

You could use:

assignee CHANGED AFTER startOfDay()

^ This would provide all Issues which have had the Assignee changed (in any way) since the start of the day, based on the current day.

Ste

[Taha El Majidi]

Hi @Ste Wright ,

The assignee changed does not necessary mean that the issue was not already assigned to someone else.

[Ste Wright]

Hi @Taha El Majidi 

Sure - so what is the exact need you're looking for, if not the above?

Ste

[Taha El Majidi]

Hi @Ste Wright ,

I think @Pourna Radha-Burhoo is looking for issues assigned for the first time during the day.

[Ste Wright]

Ah, got yourself and Swarna mixed up there!

If it's different to what is needed, I'm sure they'll let us know :)

Ste