Creation of filter for current daily ticket

[Rodriguez_ Jhon Ronald]

Can some one help me to input the correct JQL code for the daily ticket created.

I want to display it on our dashboard hourly.

Thanks

[Paloma Fondon Araujo · Accepted solution]

Hi @Rodriguez_ Jhon Ronald 

You could try the following JQL:

project = "XXXX" and createdDate >= startOfDay ()

I hope it helps you.
Greetings

[Rodriguez_ Jhon Ronald]

JQL is working. Thanks for the help.

[mogavenasan · Accepted solution]

Hi @Rodriguez_ Jhon Ronald,

If you are using the Jira dashboard to show these stats, then you can use Created vs. Resolved Chart gadget. You can group created issues by hourly.

[Rodriguez_ Jhon Ronald]

Created vs. Resolved Chart is not working on us..

maybe you could share for the JQL instead.

[Zoryana Bohutska _SaaSJet_]

Hi @Rodriguez_ Jhon Ronald 

For the next cases when you don't know how to build the right JQL, you can try Dynamic Filter: JQL Replacer for Jira (created by my team). It allows generating requests to Jira without JQL knowledge.

For example, for your question, you can create such a request as in the screenshot.

Regards